Solve the Problem of mysql5.0 garbled code!

1. Set default-character-set = Latin1 in my. ini to default-character-set = GBK.

2. Specify the UTF-8 character set when creating a table, for example:

Create Table hluser (
Userid char (20) not null,
Username char (20) not null,
Userpwd char (50) not null,
Primary Key (userid)
) Engine = MyISAM default charset = utf8;

3. In JSP:

<% @ Page session = "true" contenttype = "text/html; charset = gb2312" %>

<Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312">

 

In this way, the Chinese characters inserted by the database are not garbled; During the JSP page display process, Character Set conversion is not required, and Chinese characters can be displayed normally.

Test it yourself!