SELECT COLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS', 'CodePage')
The return value is 936, which is GBK encoding.
936 Simplified Chinese GBK
950 Traditional Chinese BIG5
437 United States/Canada English
932 Japanese
949 Korean
866 Russian
65001 unicode UFT-8
If the field has Chinese characters and the PHP file setting encoding is GBK2312, there will be no problem when fetching the database information:
print_r($rs["Customer Code"]);
If If the PHP file is set to encoding utf-8, an error will be reported.
If you must set the encoding of the PHP file to utf-8, you need to convert the encoding:
print_r($rs[mb_convert_encoding("Customer encoding","GBK","UTF -8")]);//Print the record array
This way there will be no problem.