设置默认字符集.[mysqld]
skip-innodb
local-infile=1
basedir=F:/WXQ/mysql
datadir=F:/WXQ/mysql/data
port=3306
default-character-set = gb2312default-character-set = gb2312
就是你要在你的 my.ini 中加入的 你可以使用 BIG5 字符集.
skip-innodb
local-infile=1
basedir=F:/WXQ/mysql
datadir=F:/WXQ/mysql/data
port=3306
default-character-set = gb2312default-character-set = gb2312
就是你要在你的 my.ini 中加入的 你可以使用 BIG5 字符集.
String user = "root";
String password = "12345678";
Connection connRemoteMysql = DriverManager.getConnection(url, user, password);
I got "?" in DB when store "許"
mysql> desc haha;
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| name | varchar(15) | | | | |
| job | varchar(200) | | | | |
+-------+------------------+------+-----+---------+----------------+
3 rows in set (0.06 sec)mysql> select * from haha;
Empty set (0.01 sec)mysql> insert into haha(name) values ('許');
Query OK, 1 row affected (0.08 sec)mysql> select * from haha;
+----+------+-----+
| id | name | job |
+----+------+-----+
| 1 | 許 | |
+----+------+-----+
1 row in set (0.00 sec)mysql>
mysql> insert into haha(name) values ('許許許許許');
Query OK, 1 row affected (0.00 sec)mysql> select * from haha;
+----+------------+-----+
| id | name | job |
+----+------------+-----+
| 1 | 許 | |
| 2 | 許許許許許 | |
+----+------------+-----+
2 rows in set (0.00 sec)
Can u search it in your db ?
select * from user where name like '%許%'
+----+------------+-----+
| id | name | job |
+----+------------+-----+
| 1 | 許 | |
| 2 | 許許許許許 | |
+----+------------+-----+
2 rows in set (0.00 sec)all looks like right...hehe