Cetin,
Can you explain me something?
I have WindowsXP (English) and Regional and Language Options I have "Language for non Unicode program" - Russian.

FoxPro.. I have database and Tables with Codepage 1252 (config.fpw by default)

When I fill VS.NET datagrid - codepage missed... (some characters missed - Encrypt() not works)
Then.. I change codepage of VFP table to 1251 ... and VS.NET display all fields right... - Encrypt() works)

I'd like to ask.. why it happen? VFPOLEDB translate and return datatable in codepage like my "non Unicode" settings? Why in VFP I must use one codepage... for .NET I must translate table to another codepage? Is there way to select codepage in connection string? for VFPOLEDB...

And more... how you think... why VFPOLEDB translate it from 1252 to 1251 for DataTable? what reason? why not used codepage of file?

But... what I afraid..... when I delivery data to customer... there exist a chance when customer using another regional settings.. and..? Encrypt will fail... What shell do in .NET? At first time application start, before database open ask user about codepage? and then convert it... Which way is right?

Thanks.
Denis



>>Hello,
>>I have next problem
>>My VFP table has 1252 codepage.. When I using .NET and DataAdapter.Fill() I preview my data in DataGrid. The codepage is not same.
>>Problem - I using CIPHER encrypted columns. and encrypt wrong from .NET because strings is not correct.. Some is ok.. but some string ASC() for characters wrong..
>>
>>
>>Question. How do I get same codepage in .NET datatable?
>>
>>Thanks
>>Denis.
>
>Denis,
>Thread #1043844 might help.
>However for things like an encrypted password, GUID and alike use char (binary) or memo (binary) datatypes in VFP tables to prevent any codepage translation.
>PS: Check for a message titled something like "valid GUID" earlier today in VFP section for a sample.
>Cetin