[OpenSER-Devel] Too long keys for UTF-8

Jan ONDREJ (SAL) ondrejj at salstar.sk
Mon Mar 17 10:40:46 CET 2008


Hello,

  when trying to create openser mysql databases using UTF-8 as mysql default
encoding, create scripts fails with:

[ondrejj at work openserctl]$ openserdbctl create
MySQL password for root:
INFO: test server charset
INFO: creating database openser ...
ERROR 1071 (42000) at line 2: Specified key was too long; max key length is
1000 bytes
ERROR: Creating core tables failed!

Can somebody lower some string lengths to avoid this problem?
I think UTF-8 is a preffered encoding for most cases.

		SAL



More information about the Devel mailing list