MySQL error

[Paul Cullen]

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]

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