RE: Foreign Key Reference to a VARCHAR

2004-02-10 Thread Sven Woltmann
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

RE: Foreign Key Reference to a VARCHAR

2004-02-10 Thread Sven Woltmann
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

Foreign Key Reference to a VARCHAR

2004-02-09 Thread Sven Woltmann
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