Re: data type and Character set for DUTCH language
utf8 is the CHARACTER SET for most situations where non-English characters are needed.
Most of the utf8 COLLATIONs will work the same for Dutch. I suggest utf8_unicode_ci. There are various COLLATIONs to handle the differences in Spanish, Polish, Estonian, etc.
utf8_bin puts all accented letters after the 'z', hence not good for ordering.
utf8_general_* may be less desirable for Dutch because they do not treat the ij ligature ("ij") as equal to the two characters "ij".
http://mysql.rjweb.org/doc.php/charcoll#utf8_collations
and the following section elaborate on the main European COLLATIONs available in MySQL.
Subject
Views
Written By
Posted
4721
July 23, 2013 05:57AM
Re: data type and Character set for DUTCH language
2694
July 24, 2013 08:57AM
2143
July 27, 2013 02:19AM
2731
July 28, 2013 03:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.