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

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

php - Multiple Select with Explode: only returns the word "Array" -

php - jQuery AJAX Post not working -