List:General Discussion« Previous MessageNext Message »
From:Chris Date:January 28 2006 2:59am
Subject:Re: help with character sets and collation
View as plain text  
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" <Gleb.Paharenko@stripped> wrote in message 
news:20060127134742.2667.qmail@ style="color:#666">stripped...
> 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" <Gleb.Paharenko@stripped> wrote in message
>> news:20060126161300.611.qmail@ style="color:#666">stripped...
>>
>>>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
>>>/ /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
>>>/_/  /_/\_, /___/\___\_\___/   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
> / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
>       <___/   www.mysql.com 


Thread
help with character sets and collationChris26 Jan
  • Re: help with character sets and collationGleb Paharenko26 Jan
  • Re: help with character sets and collationChris26 Jan
    • Re: help with character sets and collationGleb Paharenko27 Jan
  • Re: help with character sets and collationChris28 Jan
    • Re: help with character sets and collationGleb Paharenko28 Jan
  • Re: help with character sets and collationChris28 Jan