* Set table charset to latin1 for MySQL or we exceed the MySQL index length limitation
MySQL has an index limitation of 1000 bytes. Using some character sets, especially UTF-8 requires 3x the number of bytes for storage and exceeds this limit in some tables. -N
Index: convert-tsql =================================================================== --- convert-tsql (revision 252) +++ convert-tsql (working copy) @@ -55,7 +55,7 @@ sed \ -e 's/@PRELOAD@/SET FOREIGN_KEY_CHECKS=0;/' \ -e 's/@POSTLOAD@/SET FOREIGN_KEY_CHECKS=1;/' \ - -e 's/@CREATE_TABLE_SUFFIX@/TYPE=InnoDB/' \ + -e 's/@CREATE_TABLE_SUFFIX@/TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_bin/' \ -e 's/@SERIAL_TYPE@/SERIAL/' \ -e 's/@BIG_INTEGER@/BIGINT UNSIGNED/' \ -e 's/@TRACK_KEY_LEN@/255/' \ @@ -66,7 +66,7 @@ sed \ -e 's/@PRELOAD@/SET FOREIGN_KEY_CHECKS=0;/' \ -e 's/@POSTLOAD@/SET FOREIGN_KEY_CHECKS=1;/' \ - -e 's/@CREATE_TABLE_SUFFIX@/TYPE=InnoDB/' \ + -e 's/@CREATE_TABLE_SUFFIX@/TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_bin/' \ -e 's/@SERIAL_TYPE@/SERIAL/' \ -e 's/@BIG_INTEGER@/BIGINT UNSIGNED/' \ -e 's/@TRACK_KEY_LEN@/512/' \
signature.asc
Description: This is a digitally signed message part
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________ policyd-users mailing list policyd-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/policyd-users
