-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Andrew Dunbar wrote:
- Does mysql support UCS-2, UTF-8, or UCS-4 beyond the BMP?
UCS-2 does not include anything beyond the BMP, by definition.
(Further, UCS-2 is supported only for storage; connections to the server must use another charset such as UTF-8, and the conversion on the server end is indeed limited to UCS-2. While it is possible as of my testing last year to store UTF-16 data in UCS-2 fields by communicating with the server using invalid pseudo-UTF-8 which encodes the UTF-16 surrogate pair halves as separate UTF-8 characters, this would be very fragile and likely to lead to bugs, interoperability problems, and data corruption.)
UTF-8 support in MySQL is limited to 3-byte characters, which corresponds to the BMP.
UCS-4 is not supported at all.
- -- brion vibber (brion @ pobox.com)