Page 1 of 1

Unicode for Russian

Posted: Fri Aug 11, 2006 4:25 am
by deeppak
I just wanted to insert Russian data in my database(MySql) but while I insert it it get inserted easily, since I believe the data is inserted in the default format i.e. UTF-8 Unicode (utf8) i believe this is the default format but when i select it from database i could not get what was desired what is the solution for this, I am using Php as server side language..

I get ?????? as a result of select and while i look it in phpadmin the result is the same, is this the browser problem...which is not supporting the font.

or else I have to insert data in some specific uniccode..

Thanx,
Deeppak 8O

Posted: Fri Aug 11, 2006 4:33 am
by Weirdan
to get that working you have to make sure that all the links in the chain user->php->database->php->user are working in the same encoding (or perform proper conversion(s)). The behavior you observe is an indication that some link(s) do not handle encoding as intended. Usually it php<->database part. Make sure you send the SET NAMES utf8 command to your db before performing any other queries.

Posted: Fri Aug 11, 2006 4:34 am
by volka
Does your browser render the characters at http://en.wikipedia.org/wiki/Cyrillic_alphabet correctly?

Posted: Fri Aug 11, 2006 5:39 am
by jamiel
Try iconv

Posted: Fri Aug 11, 2006 5:52 am
by Weirdan
Try iconv...
...unless it's possible to get things done without it

Posted: Fri Aug 11, 2006 7:53 am
by Ambush Commander
Are you sure the form submissions are being done in UTF-8?