Some tables are in latin1_swedish_ci

Some tables are left with the default endocing of mysql latin1_swedish_ci and this is creating problems in some languages even though they use latin alphabet with additional letters.
With with utf8_unicode_ci this problem is not seen.
may be all content tables to be in a broader encoding not to have these problems.

  • View
    499
  • More
Replies (5)

    • As a solution I changed all tables with sql queries and their columns to utf8mb4_unicode_ci now everything seems like normal.
      For users this is a sensitive operation and you should backup your database first!

      • C

        Cem bey merhaba,

        Türkçe karekter sorununu nasıl çözebiliriz?

        • şuanda bir sorun olmaması lazım, nerede sorun yaşıyorsunuz?

          • i wonder myself if this is necessary, i changed my entire database to utf8mb4_unicode_ci about 6 weeks ago, after reading about collations on oracles website for about 3 hours :)

            • C

              trkçe karekterleri kabul etmiyor

              Login or Join to comment.