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]
