Skip navigation links

MySQL Forums :: Perl :: Cyrillic, Perl and MySql problem


Advanced Search

Re: Cyrillic, Perl and MySql problem
Posted by: Richard Jones ()
Date: March 10, 2010 12:31PM

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

Options: ReplyQuote


Subject Written By Posted
Cyrillic, Perl and MySql problem Richard Jones 03/06/2010 09:50PM
Re: Cyrillic, Perl and MySql problem Richard Jones 03/10/2010 12:31PM
Re: Cyrillic, Perl and MySql problem Rick James 04/04/2010 10:54PM
Re: Cyrillic, Perl and MySql problem Ventsislav Alexandriyski 04/10/2010 09:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.