Czech sorting installation
Vložil admin, Po, 2006-04-17 14:58
linux
mySQL
3.23
Correct czech sorting (included "ch") in mySQL is set using --default-character-set=czech directive on mysqld daemon command line, e.g. in /etc/rc.d/init.d/mysql file. After restarting was impossible connect to server. Problem is in changed code page - old indexes were created with different code page. Solution: recreate whole database:
linux
mySQL
3.23
Correct czech sorting (included "ch") in mySQL is set using --default-character-set=czech directive on mysqld daemon command line, e.g. in /etc/rc.d/init.d/mysql file. After restarting was impossible connect to server. Problem is in changed code page - old indexes were created with different code page. Solution: recreate whole database:
-
export data, mysqldump --all-databases --add-drop-table > /tmp/mydump.dmpimport data, mysql < /tmp/mydump.dmp
» Přihlašte se, abyste mohl psát komentáře | Czech | 6624 x přečteno