MySQL Forums
Forum List  »  Perl

Cyrillic, Perl and MySql problem
Posted by: Richard Jones
Date: March 06, 2010 09:50PM

I created a language tag system using MySql.
no problems except with Russian.

I set the ru_lang tabel to use utf8
that still did not work.
I tried all kinds of stuff with Perl all to no avail.

Here is what my problem is.

If I use my language editor I developed in Perl the form changes the russian language to html encoded entries such as this:

English was:
Click here if your billing address is the same as your shipping address
Changed english to Russian:
Нажмите здесь, если совпадает с вашей биллинг адресом вашего адреса отгрузки
When I save using the webform I see this in the table:
Нажмите здесь, если совпадает с вашей биллинг адресом вашего адреса отгрузки

which does display ok on the webpage, unless it is a label of a checkbox or submit button or something like that.

If I use PhpMyAdmin to update it, then it stores the correct character set:
Нажмите здесь, если совпадает с вашей биллинг адресом вашего адреса отгрузки

However, that shows on the webpage as all ??? marks:
??????? ?????, ???? ????????? ? ????? ??????? ??????? ?????? ?????? ????????

Any idea why that is happening?
Here is my character encoding page type:
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Content-language" content="RU">

So that is not it.

I am completely confused as to why this does not work.
I hope someone can help me.
thank you,
Richard

Options: ReplyQuote


Subject
Written By
Posted
Cyrillic, Perl and MySql problem
March 06, 2010 09:50PM


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.