aspose file tools*
The moose likes JDBC and the fly likes MySQL error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL error" Watch "MySQL error" New topic
Author

MySQL error

Paul Cullen
Greenhorn

Joined: Sep 07, 2007
Posts: 11
I have set the encoding in MySql as utf8.
But when I try to insert a entry into the table, I get

mysql> INSERT INTO verbTable6 VALUES(1,'to be','Irregular','present','I','t�im',
'n�lim');
ERROR 1366 (HY000): Incorrect string value: '\xA0im' for column 'positive' at ro
w 1
Paul Cullen
Greenhorn

Joined: Sep 07, 2007
Posts: 11
I was able to add to database partially when turned strict mode off.But cant seem to add whole words to the database in the positive and negative columns when I use words with �,�,�,�,�.


mysql> INSERT INTO verbTable6 VALUES(1,'to be','Irregular','present','I','t�im',
'n�lim');
Query OK, 1 row affected, 2 warnings (0.03 sec)




mysql> SELECT * FROM verbTable6 WHERE word = 'to be' AND tense = 'past';
+------+-------+-----------+-------+-------------+----------+----------+
| id | word | verbType | tense | englishForm | positive | negative |
+------+-------+-----------+-------+-------------+----------+----------+
| 16 | to be | Irregular | past | I | bh | n |
| 17 | to be | Irregular | past | You | bh | n |
| 18 | to be | Irregular | past | He | bh | n
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL error