I think I have a problem with mysql related character sets and collation.
With language English (en-utf-8), MySQL charset UTF-8 Unicode and a MySQL
connection collation: ascii_general_ci. I can execute a sql statement in
phpmyadmin, like "INSERT INTO mytable (id, name) VALUES ('5','Unterwinkel
Straáe')"
But if I try to execute the insert using a php script I get the error 1406
record too long. Using the same insert but without the á character, the sql
statement works. INSERT INTO mytable (id, name) VALUES ('5','Unterwinkel
StraXe')"
How would I configure mysql so characters like á can be inserted without
problems.
Thanks
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
