On Saturday, December 10, 2011 at 04:20:25 PM, Jon Forsyth wrote:
> Hello,
>
> I hope someone can help me solve this. I am trying to write 2 string
> values to separate fields of the same row in a mysql DB table using the
> Perl Module DBD::mysql. One string value is of English letters, while th
You may want to check "character_set_results" variable through
> SHOW VARIABLES LIKE 'character_set%';
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
ch
What happens if your Perl script generates (UTF8) SQL output instead of sending
the Perl Module it? Does it look right?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello Michaël,
Thank you for the tips. SHOW CREATE TABLE helped me figure out that my
table was using Latin1 and I was able to change it to utf-8. However, I
did not see any encoding specified on the column with this command.
I tried to fix the connection encoding with this line of Perl code:
Hello,
I hope someone can help me solve this. I am trying to write 2 string
values to separate fields of the same row in a mysql DB table using the
Perl Module DBD::mysql. One string value is of English letters, while the
other is of Arabic letters. However, they are somehow switched and writte
