>>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)
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham