Mysql convert unicode code point to utf-8 character

mysql utf-8 char codepoint
Adee picture Adee · Feb 12, 2013 · Viewed 7.1k times · Source

I was using CHAR(code_point USING ucs2) to convert a unicode code point to utf-8 character but it's giving me unexpected results above 0x00ff code point. It gives me the the character Ā (code point 0x0100) against code points 0x0100 to 0x01FF, and character Ȁ (code point 0x0200) for code points 0x0200 to 0x02FF, and so on.

So if I execute this query:

SET NAMES utf8;
SELECT CHAR(0x0100 USING ucs2),CHAR(0x0101 USING ucs2),CHAR(0x0200 USING ucs2),CHAR(0x0201 USING ucs2);

, it gives me the result:

| Ā | Ā | Ȁ | Ȁ |

whereas the expected result is:

| Ā | ā | Ȁ | ȁ |

Please help me understanding the problem, or suggest another way of doing this.

Thanks in advance..

Answer

Adee picture Adee · Feb 12, 2013

I got it working by doing this

CONVERT(CHAR(code_point) USING ucs2);

I have to mix the characters with utf8, so I have to further convert into utf8

CONVERT(CONVERT(CHAR(code_point) USING ucs2) USING utf8);

Related questions

What's the difference between utf8_general_ci and utf8_unicode_ci?

Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?

Read More
"Incorrect string value" when trying to insert UTF-8 into MySQL via JDBC?

This is how my connection is set: Connection conn = DriverManager.getConnection(url + dbName + "?useUnicode=true&characterEncoding=utf-8", userName, password); And I'm getting the following error when tyring to add a row to a table: Incorrect string value: '\xF0\…

Read More
SET NAMES utf8 in MySQL?

I often see something similar to this below in PHP scripts using MySQL query("SET NAMES utf8"); I have never had to do this for any project yet so I have a couple basic questions about it. Is this something …

Read More