docs:mysql:character_sets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
docs:mysql:character_sets [2007/03/21 01:23] – billhdocs:mysql:character_sets [2008/08/03 00:25] (current) – external edit 127.0.0.1
Line 4: Line 4:
   * List collation for character set   * List collation for character set
     * SHOW COLLATION LIKE 'latin1%';     * SHOW COLLATION LIKE 'latin1%';
 +  * Find character set and collation for a specific database
 +    * SHOW CREATE DATABASE databasename;
 +  * Find character set and collation for a specific table
 +    * SHOW CREATE TABLE tablename;
 +  * Find character set and collation for columns
 +    * SHOW FULL COLUMNS FROM tablename;
  
 ===== Changing/Setting the Character Set ===== ===== Changing/Setting the Character Set =====
Line 15: Line 21:
 ===== See Also ===== ===== See Also =====
   * [[alter_table|ALTER TABLE]]   * [[alter_table|ALTER TABLE]]
 +  * [[show|SHOW]]
  
 ===== External Links ===== ===== External Links =====
   * http://dev.mysql.com/doc/refman/4.1/en/charset.html   * http://dev.mysql.com/doc/refman/4.1/en/charset.html
  • docs/mysql/character_sets.1174461809.txt.gz
  • Last modified: 2008/08/03 00:25
  • (external edit)