Check characgter set name and collation name : INFORMATION_SCHEMA « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. INFORMATION_SCHEMA

Check characgter set name and collation name

        
mysql>
mysql> CREATE TABLE CHARSETHP8
    ->       (C1  CHAR(10) NOT NULL,
    ->        C2  VARCHAR(10))
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT   COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME
    -> FROM     INFORMATION_SCHEMA.COLUMNS
    -> WHERE    TABLE_NAME = 'CHARSETHP8';
+-------------+--------------------+-------------------+
| COLUMN_NAME | CHARACTER_SET_NAME | COLLATION_NAME    |
+-------------+--------------------+-------------------+
| C1          | latin1             | latin1_swedish_ci |
| C2          | latin1             | latin1_swedish_ci |
+-------------+--------------------+-------------------+
2 rows in set (0.00 sec)

mysql>
mysql>
mysql> drop table charsethp8;
Query OK, 0 rows affected (0.00 sec)

mysql>

   
    
    
    
    
    
    
    
  

Related examples in the same category