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
I saw that in some complex query of mine where I expected "date" I saw
"varchar(29)". The relevant part is that the first argument to "ADDDATE" is the
"LEAST" of two DATEs.
Unhappilie, all the type changes are clearly documented--the most annoying is
"LEAST" :
In all other cases, the arguments
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:
InterBase, Firebird
and MySQL.
There's a 40% discount available until the 1st of January 2012!
For more information, see http://www.upscene.com/go/?go=news&id=20111212
For a full list of fixes in this release, see:
http://www.upscene.com/go/?go=tracker&v=4.2.0&id=3
