>>>In general I don't mind changing the type of field in SQL Server but I have to also change the type of field on the VFP side (specifically when I SQL Select or fill a Cursor Adapter). I need to test it.
>
>Yes. In VFP View designer, set the field to character binary which will work against whatever field type you choose on the backend.
>
>FWIW, don't be tempted to use CHAR or TEXT in SQL Server for binary strings. They've promised to deprecate TEXT for years but (more importantly) some character combinations are quietly transformed by SQL Server for those field types which gives you an intermittent bad encryption that's expensive to debug in a non-human-readable encrypted string.
I don't use View Designer.
I would need to check, first, if CA support Character (Binary) type field. That is, if you can map a Binary field in SQL Server to Character(Binary) in VFP
"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
