Re: Cyrillic, Perl and MySql problem

[Richard Jones]

Been working on it toying with different ideas, and I have come up with an idea, as to what is causing the ??? marks...

When I run this in my perl, just before I run a query:

$dbh->do(qq~SET CHARACTER SET cp1251~);

Then it changes from ? marks to this:

Value in database:
Нажмите здесь, если совпадает с вашей биллинг адресом вашего адреса отгрузки

Value displayed on page:
Íà æìèòå çäåñü, åñëè ñîâïà äà åò ñ âà øåé áèëëèíã à äðåñîì âà øåãî à äðåñà îòãðóçêè

According to this page:
http://www.collation-charts.org/mysq...eneral_ci.html
cp1251 does contain those character sets. so I am not sure why that does not work, because if I set the character set to cp1251_general_ci I still see this:
??????? ?????, ???? ????????? ? ????? ??????? ??????? ?????? ?????? ???????? very curious to me... not sure what that is happening.

So that does change it, it does not fix it, but it changes it.
If I set the character set to:
koi8r it changes:
Нажмите здесь, если совпадает с вашей биллинг адресом вашего адреса отгрузки
to:
îÁÖÍÉÔÅ ÚÄÅÓØ, ÅÓÌÉ ÓÏ×ÐÁÄÁÅÔ Ó ×ÁÛÅÊ ÂÉÌÌÉÎÇ ÁÄÒÅÓÏÍ ×ÁÛÅÇÏ ÁÄÒÅÓÁ ÏÔÇÒÕÚËÉ

So that also changes it... not ? marks but still not right.
according to that coalition page, it also contains the correct character set mapping that what is stored in the table uses.
http://www.collation-charts.org/mysq...eneral_ci.html

Same thing there, if I use the actual file name: koi8r_general_ci then there are still ?? marks.

I am very desperate for assistance on this, so please if anyone out there knows what I am doing right...

Thank you so much,
Richard