I'm sorry but I do not know what you mean by NO_TABLE_OPTIONS in @@sql_mode).
The database has a Collation = ascii_general_ci. The only other option is ascii_bin. With respect to the table, it also has Collation of the same, ascii_general_ci. There are many Collation types which the table may be change to, including several of the utf8 verity (utf8.bin, utf8.danish.ci,....) but no utf8 without an extension. I tried setting the table to utf8.unicode.ci, but still encounter the INSERT error as before. Thanks cw "Gleb Paharenko" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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]
