user5092 Developer Από United States Μέλος από Φεβ 2018 user5092 2 Ιουν 2018 20:55 For LiteCart 2.x, what is the preferred MySQL collation type? I noticed MySQL uses default utf8_swedish_ci, upon LiteCart installation, it gave warning message. Checking MySQL database default character set... latin1 [Warning]. The database default charset is not 'utf8' and you might experience trouble with foreign characters. Try performing the following MySQL query: "ALTER DATABASE 'database-name' CHARACTER SET utf8 COLLATE utf8_swedish_ci;" Is it ok to use uft8_swedish_ci and performing the above command ALTER DATABASE or shall the MySQL database set to different collation type prior to LiteCart installation? Thank you for feedback. Bob
tim Founder Από Sweden Μέλος από Μαΐ 2013 tim 2 Ιουν 2018 22:56 If you use latin1 you may loose character byte data when storing special characters like €. The collation suitable depends on the languages you have. utf8_general_ci will order åä after a and ö after o while utf8_swedish_ci will order åäö after z.
user5092 Developer Από United States Μέλος από Φεβ 2018 user5092 3 Ιουν 2018 00:43 Thank you for clarification.
tim Founder Από Sweden Μέλος από Μαΐ 2013 tim 3 Ιουν 2018 01:34 You can change collation after installation by going to Admin -> Languages -> Storage Encoding.
