|Problems? Is your data what you think it is?|
Can't write cyrillic to DBD::mysqlby Wolfgang (Novice)
|on Jun 29, 2010 at 09:45 UTC||Need Help??|
Wolfgang has asked for the
wisdom of the Perl Monks concerning the following question:
Hi, I am lost and need new ideas, please!
I have a DB, mysql, 5.x
I can read utf8 (Umlaute like ä ö ü or cyrillic like йцуке)
I can write Umlaute etc. without problem
I can look into the db and check the utf-codes there
I can not write cyrillic, each character is replaced by 0x3f
The problem is (probably) not in the db, because I can write cyrillic with phpmyAdmin (and read back with my script)). Pasting this sql-statement into my script does not work, though. I am definitily passing utf-encoded string to 'do'. DBI::data_string_desc says: 'UTF8 on, non-ASCII, 99 characters 105 bytes'
What kind of silly mistake could I be doing?Wolfgang