start | find | index | login or register | edit
i18n-notes
by earl, 2354 days ago
Iñtërnâtiônàlizætiøn

I%C3%B1t%C3%ABrn%C3%A2ti%C3%B4n%C3%A0liz%C3%A6ti%C3%B8n

0000000: 49c3 b174 c3ab 726e c3a2 7469 c3b4 6ec3 I..t..rn..ti..n.
0000010: a06c 697a c3a6 7469 c3b8 6e0d 0a .liz..ti..n..

(The above example includes codepoints above 127, so requireds
multi-byte sequences in UTF-8. However, the string is still in
"UCS-1": all codepoints are <255.)

------------------------------------------------------------------

·ŋŧ€®Ŋ@ŦıØNa£¡§ATıΩn

%C2%B7%C5%8B%C5%A7%E2%82%AC%C2%AE%C5%8A%40%C5%A6%C4%B1%C3%98Na%C2%A3%C2%A1%C2%A7AT%C4%B1%CE%A9n

0000000: c2b7 c58b c5a7 e282 acc2 aec5 8a40 c5a6 .............@..
0000010: c4b1 c398 4e61 c2a3 c2a1 c2a7 4154 c4b1 ....Na......AT..
0000020: cea9 6e0d 0a ..n..

// vim: set encoding=utf8:


mysql 4.1+ unicode support:

you have UTF8 data stored in VARCHAR columns where the column character set != utf8. i.e. data imported from pre-4.1 or data created by applications which don't use mysql's unicode support but store proper utf8. you want to set the proper character set for the column?

ALTER TABLE tbl MODIFY col BINARY(255);
ALTER TABLE tbl Table MODIFY col VARCHAR(255) CHARACTER SET utf8;


source: http://dev.mysql.com/tech-resources/articles/4.1/unicode.html

to convert data from such a column in a query:

CONVERT(CONVERT(col USING binary) USING utf8)
powered by vanilla
echo earlZstrainYat|tr ZY @.
earl.strain.at • esa3 • online for 6774 days • c'est un vanilla site