[ postfixadmin-Bugs-1828857 ] mysql create database broken

[SourceForge.net <no...@so...>]

Bugs item #1828857, was opened at 2007-11-09 11:00
Message generated for change (Comment added) made by xpunkt
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1828857&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: SVN (please specify revision!)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: mysql create database broken

Initial Comment:
>mysql -u root -p < DATABASE_MYSQL.TXT
Enter password:
ERROR 1071 (42000) at line 144: Specified key was too long; max key length is 1024 bytes

Using svn revision 204,
debian sarge,
mysql4-1.11a from sarge backports

changing the DATABASE_MYSQL.txt file to:
--
CREATE TABLE vacation_notification (
    on_vacation varchar(170) NOT NULL,
    notified varchar(170) NOT NULL,
-- 
fixed the problem for me tho. 

Dunno if it is a mysql bug or not.

----------------------------------------------------------------------

Comment By: Benny Pedersen (xpunkt)
Date: 2007-11-18 02:49

Message:
Logged In: YES 
user_id=774995
Originator: NO

and the vacation.pl is utf8 so we have to find a better way

----------------------------------------------------------------------

Comment By: Benny Pedersen (xpunkt)
Date: 2007-11-18 02:44

Message:
Logged In: YES 
user_id=774995
Originator: NO

problem will then be that we loose utf8 encoded email handle, is this
problem olso with postgresql and unicode ?

i prefer unicode over latin-1

----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2007-11-17 22:29

Message:
Logged In: YES 
user_id=593261
Originator: NO

Looks like an utf8 problem...

The key uses two varchar(255) field, which means the key is 2 * 255 chars
long. And utf8 means 3 bytes per char, which results in 1530 bytes.

Since these fields only contain mail addresses, I'll change them to latin1
encoding.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1828857&group_id=191583