Re^5: Can't write cyrillic to DBD::mysql

My guess, which is totally not based on any facts, is that your table/column stores its data in Latin-1, even though you can send/receive the data in utf8. I don't know enough about MySQL to know whether that's a possibility though, so take this with a large grain of salt.

Comment on Re^5: Can't write cyrillic to DBD::mysql

Replies are listed 'Best First'.
Re^6: Can't write cyrillic to DBD::mysql by mje (Curate) on Jun 29, 2010 at 12:16 UTC
It is a long time since I last used MySQL but I recollect tables needed to be created with a CHARSET. We used to do something like: `CREATE TABLE mytable ( columns ) TYPE = INNODB DEFAULT CHARSET utf8;` [download]	[reply] [d/l]
Re^7: Can't write cyrillic to DBD::mysql by Wolfgang (Novice) on Jun 29, 2010 at 12:30 UTC
That is the way I did it. Besides: It works with phpMyAdmin, so it should not be a problem of the data base itself. Wolfgang	[reply]
Re^6: Can't write cyrillic to DBD::mysql by Wolfgang (Novice) on Jun 29, 2010 at 12:35 UTC
That was my guess, too. But I can store data with phpMyadmin and I can check it with the Mysql Query Browser which shows me the binary representation. And of course, that works with characters that do not have a representation in Latin-1 So my best guess is, that some init is done wrong with perl but working with phpmyadmin Wolfgang	[reply]