Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| docs:mysql:character_sets [2007/03/21 00:02] – billh | docs:mysql:character_sets [2008/08/03 00:25] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Character Sets ====== | ====== Character Sets ====== | ||
| * List available character sets | * List available character sets | ||
| - | * SHOW CHARACTER | + | * SHOW CHARACTER |
| * List collation for character set | * List collation for character set | ||
| * SHOW COLLATION LIKE ' | * SHOW COLLATION LIKE ' | ||
| + | * 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/ | ===== Changing/ | ||
| Line 12: | Line 18: | ||
| * Each character set has one collation that is the default collation. For example, the default collation for latin1 is latin1_swedish_ci. The output for SHOW CHARACTER SET indicates which collation is the default for each displayed character set. | * Each character set has one collation that is the default collation. For example, the default collation for latin1 is latin1_swedish_ci. The output for SHOW CHARACTER SET indicates which collation is the default for each displayed character set. | ||
| * There is a convention for collation names: They start with the name of the character set with which they are associated, they usually include a language name, and they end with _ci (case insensitive), | * There is a convention for collation names: They start with the name of the character set with which they are associated, they usually include a language name, and they end with _ci (case insensitive), | ||
| + | |||
| + | ===== See Also ===== | ||
| + | * [[alter_table|ALTER TABLE]] | ||
| + | * [[show|SHOW]] | ||
| ===== External Links ===== | ===== External Links ===== | ||
| * http:// | * http:// | ||