MySQL Encoding Problems

View the current encoding status:

Mysql> show variables like \ '% character % \';

+ -------------------------- + ---------------------------- +

| Variable_name | value |

+ -------------------------- + ---------------------------- +

| Character_set_client | Latin1 |

| Character_set_connection | Latin1 |

| Character_set_database | Latin1 |

| Character_set_filesystem | binary |

| Character_set_results | Latin1 |

| Character_set_server | Latin1 |

| Character_set_system | utf8 |

| Character_sets_dir |/usr/share/MySQL/charsets/|

+ -------------------------- + ---------------------------- +

 

Change to utf8 encoding: Modify/etc/My. CNF

Add default-character-set = utf8 under [client]

Add character_set_server = utf8 under [mysqld]

Re-view the encoding status:

Mysql> show variables like 'character % ';
+ -------------------------- + ---------------------------- +
| Variable_name | value |
+ -------------------------- + ---------------------------- +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | utf8 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | utf8 |
| Character_set_system | utf8 |
| Character_sets_dir |/usr/share/MySQL/charsets/|
+ -------------------------- + ---------------------------- +

After such modification, the JDBC access will not be garbled.

Note that JSP page encoding should also be written as UTF-8.