List:General Discussion« Previous MessageNext Message »
From:Jaime Crespo Date:October 6 2009 10:00am
Subject:Re: troubles with complex UTF-8 characters
View as plain text  
On Martes, 6 de Octubre de 2009 11:03:12 Daniel Drake escribió:
> Hi,
> 
> I'm having trouble working with specific UTF-8 characters.  For
> example, the U+10330 character (UTF8: 0xF0 0x90 0x8C 0xB0).

MySQL currently only supports Basic Multilingual Plane characters: up to 3-
byte utf8 on its stable releases.
<url:http://dev.mysql.com/doc/refman/5.1/en/charset-unicode.html>

AFAIK, 4-byte encoding feature is planned, but not yet released. You could 
store non-BMP text into a blob (or other binary type), if you do not mind 
losing the benefits of character-aware fields (collation, etc.).

-- 
Jaime Crespo
MySQL & Java Instructor
Warp Networks 
http://warp.es
Thread
troubles with complex UTF-8 charactersDaniel Drake6 Oct
  • Re: troubles with complex UTF-8 charactersJaime Crespo6 Oct