Hello.
Please, execute the following statements in mysql command line and php,
and provide its output to the list:
show variables like '%char%';
show variables like '%collation%';
Include the CREATE statement for your table as well.
Chris wrote:
> 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
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
