Identify the collation used for a string by using the COLLATION() function : COLLATION « String « SQL / MySQL

1. SQL / MySQL
2. String
3. COLLATION

Identify the collation used for a string by using the COLLATION() function

   
mysql>
mysql> SELECT COLLATION('cats and dogs');
+----------------------------+
| COLLATION('cats and dogs') |
+----------------------------+
| latin1_swedish_ci          |
+----------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
  

Related examples in the same category