Using the .NET Framework 2.0 on a computer with the LCID set to 1033, I am connecting to a Sybase ASE 12.5.4 server which has its default character set to sjis.
When I retrieve fields which contain Japanese text, I must, in code, convert each field from cp1252 to cp932 to display the text properly. However, when I set the computer to LCID 1041, there is obviously no conversion in code needed.
Unfortunately, due to character sets and oddities with other data sources I have to plug in to, I must keep the computers LCID at 1033.
My question is, is there a way to specify an overall conversion for the OLEDB object or in the connection string? Converting each field one by one seems wrong.
Thank you.