ENGINE=InnoDB DEFAULT CHARSET=latin1;

Hello, I am getting an error =0A#HY000Incorrect string value: '\xE9l\x=
E9tra...' for column ' Not quite sure why. hex E9 is a lower case e ac=
ute found in CP1252 =0Aand googling seems to tell me that the latin1 charse=
t that I have set for the table should display this OK.=0A mysql V 5.0.54a =
on Redhat 5.2 =0Amysql> SHOW CHARACTER SET LIKE 'latin%';=0A+--------=
-+-----------------------------+-------------------+-------- +=0A| Charset |=
Description | Default collation | Maxlen |=0A+---------+--=
---------------------------+-------------------+--------+=0A | latin1 | cp1=
252 West European | latin1_swedish_ci | 1 Any thoughts?=0A=
=0ATIA Syd

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg