Re: 22001 Data too long for column

[data data]

I am interesting too!!! same problem with GBK chars !!!!

mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into T_User(FName,FPassword) values('我们','123');
Query OK, 1 row affected (0.01 sec)

mysql> select * from t_user;
+-------+-----------+
| FName | FPassword |
+-------+-----------+
| 我们 | 123 |
+-------+-----------+
1 row in set (0.00 sec)


but, my program is always error:

conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/d?user=root&password=mysql&useUnicode=true&characterEncoding=gbk");
Statement stmt=conn.createStatement();
ResultSet rs=null;
String temp = "insert into T_User(FName,FPassword) values('我们','123')";
PreparedStatement pst = conn.prepareStatement(temp);
pst.executeUpdate();
pst.close();


java.sql.SQLException: Unknown database 'd'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2901)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:773)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3612)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1204)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
at com.mysql.jdbc.Connection.<init>(Connection.java:408)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:270)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.main(test.java:19)