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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
