You're right - you can only code 65,536 characters with 3 UTF-bytes.
U- - U-007F: 0xxx
U-0080 - U-07FF: 110x 10xx
U-0800 - U-: 1110 10xx 10xx
Once you want to go higher than U-, you need up to 6 bytes:
U-0001 - U-001FF
Heikki,
yes, actually I use the UTF8 character set. Thanks for your
clarification and the workaround!
A few comments:
- For e-mail-addresses it's ok to set the column's character set to
latin1. And in case I need UTF8 support in a referenced VARCHAR, I'll
limit it to 85 characters. But about
n:
- 4.1.1-alpha-standard-log
- Official MySQL-standard binary
- i686
- pc-linux (debian 3.0 woody)
Sven
Schlund + Partner AG
Brauerstraße 48
76135 Karlsruhe
Dipl.-Inf. Sven Woltmann
[EMAIL PROTECTED]
http://www.schlund.de
--
MySQL Genera