>Hi,
>
>As I was just working on another problem where Rick Straul suggested the BLOB type, I thought of another place where I could use this type.
>
>I have to store a long string (of up to 300 characters) in a MEMO field. The string has nothing but "Y" and "N" (corresponding to user's privilege to this or that feature). Currently I encrypt this string with a very weak method. Which works perfectly for my type of customers and my type of business. But I would like to get rid of my encryption routine completely. So I am thinking of the following approach:
>
>Make the field W (Blob in VFP) and ?? in SQL Server. Then store this long "YN..." string into this field. I appears that VFP changes the values to some gobbledygook and therefore not readable by a human. Then I can retrieve this value, CAST it to M and use it in the program.
>
>So my question, what would be the TYPE to use in SQL Server table that I can retrieve and CAST to M?
>
>TIA
It should be varbinary(max)
If it's not broken, fix it until it is.
My Blog