Mega Code Archive

 

Categories / MySQL Tutorial / Table

 

Every database has a database character set and a database collation

The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: All database options are stored in a text file named db.opt that can be found in the database directory. CREATE DATABASE db_name     [[DEFAULT] CHARACTER SET charset_name]     [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name     [[DEFAULT] CHARACTER SET charset_name]     [[DEFAULT] COLLATE collation_name] CREATE DATABASE db_name CHARACTER SET X COLLATE Y; If both CHARACTER SET X and COLLATE Y were specified, then character set X and collation Y. If CHARACTER SET X was specified without COLLATE, then character set X and its default collation. If COLLATE Y was specified without CHARACTER SET, then the character set associated with Y and collation Y. Otherwise, the server character set and server collation. Quote from MySQL document http://www.mysql.com CREATE DATABASE db_name CHARACTER SET latin1 COLLATE latin1_swedish_ci;