Special characters and database

Hello,

I have coded a script, I have tried to post russian like this:
МАДРИД, 2 мар - РИА Новости. Супруга президента РФ Светлана Медведева в понедельник в сопровождении королевы Софии посетила Высшую школу музыки в Мадриде. Эта школа, которая носит имя королевы Софии, является наиболее престижным в Испании музыкальным учебным заведением, прежде всего благодаря работе в ней российских специалистов. Уже много лет кафедру фортепьяно в этой школе возглавляет известный русский пианист и педагог Дмитрий Башкиров, кафедру скрипки - Захар Брон, а кафедру виолончели - Наталия ...


But I have this (displayed):  http://s5.tinypic.com/156zoyw.jpg


and I have this in phpmyadmin: http://s5.tinypic.com/2d7x66e.jpg


I have this meta:
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">



and my table in my database is encoded in utf8_bin and the type is: "text"


How can I put correctly some russian, japanese, chinese etc.. ?

thanks

Read your Структура и интерпретация компьютерных программ.

That data is definitely UTF-8 Cyrillic, but it's being displayed as ISO8859-1.

You can tell this because the Đ character keeps cropping up followed by another character.  "Đ" is 0xD0 hexadecimal in ISO8859-1, which in binary is 11010000. The two character UTF-8 format is 110aaabb 10bbbbbb, where aaa is the lower three bits of the higher byte, and bbbbbbbb constitutes the lower byte. So the 100 of 11010000 indicates that the Unicode character being encoded by this UTF-8 string is of the form 0x4nn.

In short, you need to check if the charset you're using for display really is UTF-8.

>>3
Oh, forgot to add in the explanation: the Cyrillic range in Unicode is 0x400 to 0x4FF.

>>1
russian
mysql
phpmyadmin
You have too many problems for /prog/ to fix. Please make a thread for each problem so we may address them separately.

Thanks,
The /prog/ moderation team.

>>3

but why I have this: http://s5.tinypic.com/2d7x66e.jpg in phpmyadmin ?

>>6
In short, you need to check if the charset you're using for display really is UTF-8.

so

it works, nice displaying (http://i42.tinypic.com/2rh33vd.jpg), and I have this in the database when I post japanese:
0x666768666768

Is this normal ? (encoding is utf8_bin)

thanks

>>8
cool free ringtones

>>3
WHY DID YOU HAVE TO HELP HIM‽

How did you fix it?

>>10
WHY DID YOU NOT GO BACK TO /b/‽

>>12
Recognize /prog/ memes before sending people to /b/.

Here he comes, here comes speedracer,
HE'S A DEMON ON WHEELS

Here he comes, here comes speedracer,
HE'S A DEMON ON WHEELS