I noticed that my MODX database still uses latin1 character set in the database and in its tables. I would like to convert them to utf8mb4 and update collations accordingly.
I am experiencing the issue of unproper reading of cyrillic letters from MySQL table.
This is weird. As per MySQL developer website –
I have a table called ‘names’:
I was trying to convert an existing
varchar column with a
unique index on it to a
case sensitive column. So to do this, I updated the collation of the particular column.
So in my database I have thousands hebrew words which some have different vowels.
utf8_unicode_ci, are there any differences in terms of performance?
The database is
latin1_general_ci now and I want to change collation to
utf8_general_ci also is satisfactory
for both German and French, except
that ‘ß’ is equal to ‘s’, and not to
‘ss’. If this is acceptable for your
application, then you should use
utf8_general_ci because it is faster.
it is more accurate.
I’m trying to figure out what collation I should be using for various types of data. 100% of the content I will be storing is user-submitted.