
Czech sorting installation
Submitted by admin on Mon, 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