Hello. I do not see the CHARACTER SET of your table (usually SHOW CREATE includes it, may be you have NO_TABLE_OPTIONS in @@sql_mode), so I assume it is the same as database character set - ascii. Check if the problem disappears after changing the character set of your fields to utf8.
Chris wrote: > Sorry, I am unable to work the command line. I have used this script > instead. > > $sql = "show variables like '%char%'"; > $result = mysql_query($sql) or die("Couldn't Select " .mysql_error()); > $count = mysql_num_rows($result); > //echo $count; > while ($row = mysql_fetch_row($result)) foreach($row as $key=>$value) echo > "$key=>$value<BR>"; > echo "<BR>"; > $sql = "show variables like '%collation%'"; > $result = mysql_query($sql) or die("Couldn't Select " .mysql_error()); > while ($row = mysql_fetch_row($result)) foreach($row as $key=>$value) echo > "$key=>$value<BR>"; > > hope this provides the appropriate info. > Thanks > > "Gleb Paharenko" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > >>Hello. >> >>Please, execute the following statements in mysql command line and php, >>and provide its output to the list: > > >> show variables like '%char%'; > > 0=>character_set_client > 1=>latin1 > 0=>character_set_connection > 1=>latin1 > 0=>character_set_database > 1=>ascii > 0=>character_set_results > 1=>latin1 > 0=>character_set_server > 1=>latin1 > 0=>character_set_system > 1=>utf8 > 0=>character_sets_dir > 1=>C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ > > >> show variables like '%collation%'; > > 0=>collation_connection > 1=>latin1_swedish_ci > 0=>collation_database > 1=>ascii_general_ci > 0=>collation_server > 1=>latin1_swedish_ci > > >>Include the CREATE statement for your table as well. > > > CREATE TABLE my_table (location_id varchar(20) NOT NULL default '',name > varchar(50) NOT NULL default '',PRIMARY KEY (location_id)) TYPE=MyISAM > > >> >>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 > > > -- 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]