ploughguy Posted September 12, 2023 Share Posted September 12, 2023 I have seen a bunch of discussions in the fora about code pages, and I read a bunch of them but did not find a definitive answer about the recommended code page for MySQL databases for CubeCart 6. Is there a recommended collation, such as utf8_unicode_520_ci? As always, thanks for your help, Russ Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted September 12, 2023 Share Posted September 12, 2023 Hi Russ, I would think that's the "best choice". However I don't know to what extent it could be overkill and if version 5.2.0 requires any more of less resources or if it makes no difference. I wish I understood a little more. There seems to be a lot of discussion as to utf8mb4_0900_ai_ci being a solid choice. Quote Link to comment Share on other sites More sharing options...
bsmither Posted September 12, 2023 Share Posted September 12, 2023 If you have direct access to the database server, in its configuration file, set collation_* to "utf8mb4_general_ci", and set character_set_* to "utf8mb4" (character_set_filesystem is "binary"). The 'mb4' part allows for several new extended sets of emojis that require 4 bytes to represent. Quote Link to comment Share on other sites More sharing options...
Eleanor1 Posted October 3, 2023 Share Posted October 3, 2023 (edited) Hii, myenvoy You can use collations like utf8mb4_unicode_ci for improved Unicode support, especially if your website caters to international audiences with diverse character sets. This collation ensures proper sorting and comparison of Unicode characters. Edited October 4, 2023 by Eleanor1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.