Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL error

 
Paul Cullen
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic