C # garbled characters in connection to MySQL (4.0)

When using C # to connect to the MySQL 4.0 database, it is found that the returned value letters and Chinese characters are normal, and only one column returns an exception. Check the database and find that the field is of the following type:

Type varchar

Length 6

Attributes binary not null

In the actual call process, it is found that the returned byte [] type, so the conversion is performed and the problem is solved. The specific conversion is as follows:

Byte [] temp = (byte []) Row ["saleunitcode"];
String temp2 = encoding. utf8.getstring (temp, 0, temp. Length );

 

Record your experiences and witness your youthful Growth