I Get It, Use UTF8 - Ummm, there are only 50 to Choose from, Do they All Work?
Message received and believed:
AGONY will be mine if I run Tiki with other than utf8! Excellent! Tiki installation program says UGLY next to the character encoding for my DB, so I am all queued up to make a replacement. So which utf8?
The choices are many.
"UTF-8 Unicode"
utf8_bin
utf8_czech_ci
utf8_danish_ci
utf8_esperanto_ci
utf8_estonian_ci
utf8_general_ci
utf8_general_mysql500_ci
utf8_hungarian_ci
utf8_icelandic_ci
utf8_latvian_ci
utf8_lithuanian_ci
utf8_persian_ci
utf8_polish_ci
utf8_roman_ci
utf8_romanian_ci
utf8_sinhala_ci
utf8_slovak_ci
utf8_slovenian_ci
utf8_spanish2_ci
utf8_spanish_ci
utf8_swedish_ci
utf8_turkish_ci
utf8_unicode_ci
utf8mb4_bin
utf8mb4_czech_ci
utf8mb4_danish_ci
utf8mb4_esperanto_ci
utf8mb4_estonian_ci
utf8mb4_general_ci
utf8mb4_hungarian_ci
utf8mb4_icelandic_ci
utf8mb4_latvian_ci
utf8mb4_lithuanian_ci
utf8mb4_persian_ci
utf8mb4_polish_ci
utf8mb4_roman_ci
utf8mb4_romanian_ci
utf8mb4_sinhala_ci
utf8mb4_slovak_ci
utf8mb4_slovenian_ci
utf8mb4_spanish2_ci
utf8mb4_spanish_ci
utf8mb4_swedish_ci
utf8mb4_turkish_ci
utf8mb4_unicode_ci
Now, you might think I should just know which to pick but considering that for a long time the correct pick was Swedish Latin, which made no sense to me, how can I know which of these to pick?
Related... I thought utf8 is unicode. So why are only two of these named unicode. That looks like the others must not be unicode.
Not really for this forum but I do want to know: if utf8 is the thing to run, what is going on with WordPress, running mb4? Or is that utf8mb4? The only thing I know for sure is that in the last 10 years, only one of more than 1,000 databases I have worked with gave me a problem when I read the data from the database using php and mysql, and that one is WordPress database using UTF8, but a different UTF8 than what I was needing I guess.
I have every faith that using utf8 for tiki is going to save agony. I think tiki software is great.
Thank you for your assistance on making sure I don't foul it up with the wrong character encoding.