What is MySQL Collation, how to use it in practice? -
Let's say I want to create search engines in some strange languages in 4 languages:
English Swedish Hebrew Arabic
How do I set up the collation in MySQL?
Coalition determines how MySQL compares strings.
A list of all the character sets and collisions can be found in this way:
Show pigment set; Show COLLATION;
To change the collation for table use:
optional table `my_table` Default character set UTF8 COLLATE utf8_unicode_ci
Comments
Post a Comment