PHP

PHP encoding conversion


SELECT COLLATIONPROPERTY(‘Chinese_PRC_Stroke_CI_AI_KS_WS’, ‘CodePage’)

It returns 936, or the GBK encoding.

936 simplified Chinese GBK 950 traditional Chinese BIG5 437 American/Canadian English 932 Japanese 949 Korean The 866 Russian 65001 unicode UFT-8

If the field is in Chinese and the PHP file is set to GBK2312, there will be no problem when fetching the database information:

print_r($rs[” customer code ”]);

If the PHP file is set to utf-8, an error is reported.

If you want to set the encoding of php file to utf-8, you need to convert the following encoding:

print_r($rs[mb_convert_encoding(” customer code ”,“GBK”,” UTF-8 ”)); // print record array

There’s no problem.