Home > Net >  C # sybaseIQ library via the ODBC connection, query results showed garbled in Chinese
C # sybaseIQ library via the ODBC connection, query results showed garbled in Chinese

Time:10-19

Oo??? On? Ye ˉ oi ·? 1???????

Like the noise, this is what the code, how to deal with

CodePudding user response:

is shown in figure

CodePudding user response:

Do not match the encoding format your database, such as utf8

CodePudding user response:

Suggest directly use convenient is essentially a lot

CodePudding user response:

to celebrate, the super trouble, Sybase is very old, so the data is not all

You use ODBC to connect, to look at the character set of ODBC, Sybase has two kinds, in Chinese CP936 and UTF8, you first find out which one, and then select the corresponding code, test ODBC first display is normal

If there are problems, I don't know.

My side is CP936, using OLEDB, no special setup can identify Chinese
Connectstr="Driver={the Adaptive Server Enterprise}; Server=192.0.0.1; Uid=sa; The Pwd=password; Port=6100; Cp=936;

I wish you good luck, this broken item I waste a lot of time

CodePudding user response:

Set to not cp936 and utf8, in addition to the ODBC connection sybaseIQ library can also use what kind of way
  •  Tags:  
  • C#
  • Related