Phpadmin and Dreamweaver Test SQL instructions in Chinese display as question mark questions, please php+mysql expert answers
I used the Wamp,apache+php+mysql phpadmin to tabulate the database, and in phpadmin I've adjusted all the character sets to gb2312
Include Preferences in PHP Web pages
, and also adjusted the MySQL code, the code for the database (including fields, table) is gb2312
However, when testing, the page still cannot display the PHP section of Chinese (displayed as a question mark)
The character set of the show variables in cmd has been viewed,
Tried the separate execution: set character_set_xxxx=gb2312;
Even if the whole display is gb2312, still invalid;
Attempt to write up set NAMES gb2312 or add set NAMES gb2312 in *.sql and repeatedly import and export to read and write, invalid;
Also tried to modify the default Default-character-set=utf8 in My.ini invalid (cannot start after modification);
It is also invalid to attempt to unify all the coding involved into utf-8.
Ask the expert to answer the question where it appears?
I'm new, but I'm asking for details. If it can be resolved, be grateful, add 100, words will be done.
-------------------------
Win7x64
Apache 2.2.21
PHP 5.3.8
PHP Extension: mysqli
MySQL 5.5.16
MySQL Client version: Mysqlnd 5.0.8-dev-20102224-$Revision: 310735 $
phpadmin:3.4.5
MySQL PHP SQL Dreamweaver Test
------Solution--------------------
It is important to note that all changes to the character set settings do not affect the data in the library.
The only effect is to change the data after setting
------Solution--------------------
1, confirm php file asked gb2312 code
2, the query before execution: mysql_query ("SET NAMES gb2312");
------Solution--------------------
Analysis Method:
1. Verify that the Chinese you inserted into the database is a question mark. If so, that's the problem with inserting the data, execute before you run the INSERT statement: mysql_query ("SET NAMES gb2312");
2. If the database data is normal, it is your page encoding error carefully check the meta information word is correct, you can also directly copy the other local source code, meta.
3. If it is not resolved, add: mysql_query ("SET NAMES gb2312") before reading the data code of the database;
I hope my answer will be of help to you.
