User: bogdan_iancu
Date: 2006/12/05 10:51:09 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh
Commit Log:
Fixed problem when creating tables using default "utf8" or "ucs2" charsets -
they use 3 bytes for char and generates error about the lenght of the keys:
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
Solution was to:
1) Test what's the character encoding is used in database.
2) If it's a UCS-2 or UTF8 (where 3 bytes per char are used) then warn
user that db couldn't be created and prompt him to select another
character encoding among available.
3) In a "CREATE DATABASE" use closure "CHARACTER SET"
Patch submitted by Khalukhin Alexander <[EMAIL PROTECTED]>.Thanks!!
Closes bug 1605410.
http://sourceforge.net/tracker/index.php?func=detail&aid=1605410&group_id=139143&atid=743020
Revision Changes Path
1.44 +22 -2 sip-server/scripts/mysqldb.sh
[
http://openser.cvs.sourceforge.net/openser/sip-server/scripts/mysqldb.sh?r1=1.43&r2=1.44
]
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
