Opened 8 years ago

Last modified 8 years ago

#212 new defect

non-unicode mysql database is not nice

Reported by: frank habermann Owned by: frank habermann
Priority: minor Milestone: 1.1
Component: knowledgeroot base system Version: 1.0
Keywords: database unicode utf8 Cc:

Description

Direct review data in mysql tables knowledgeroot (for administration and debug purpose) is impossible for non-english

default mysql charset is latin-swedish by default global change charset in my.cnf is not right == double-size any database

Fix: dumps/mysql.sql replace all ) ENGINE=MyISAM AUTO_INCREMENT=1 ; to ) ENGINE=MyISAM AUTO_INCREMENT=1 CHARACTER SET utf8 COLLATE utf8_unicode_ci;

also check/migrate existing data possible use of use names utf8 in mysql

Change History (1)

comment:1 Changed 8 years ago by frank habermann

Milestone: 1.0.31.1
Note: See TracTickets for help on using tickets.