What are the commands to enable and disable case sensitivity by default for an entire database on a MySQL server? I'm aware of the COLLATE statement, but it seems it's necessary to place this in every SQL statement that's run. Is there an option to set this globally?

• Mysql Database Name Case Sensitive

If you want a column always to be treated in case-sensitive fashion, declare it with a case-sensitive or binary collation. See Section 13.1.18, “CREATE TABLE Syntax”. To cause a case-sensitive comparison of nonbinary strings to be case insensitive, use COLLATE to name a.

Cerin

Mysql Database Name Case Sensitive

Cerin

2 Answers

You can set collation at both the database creation and table creation level as a part of the CREATE TABLE statement.

To set the collation for the entire database, you can use:

You can also change the collation on an existing database via ALTER DATABASE. (For more information see the MySQL Database Character Set and Collation manual entry.)

If however, only a single table needs to be treated as case sensitive, you could simply use:

(Case insensitive being 'utf8_general_ci'.)

Finally, the main MySQL Character Set Support manual section is probably worth a quick peruse. (It lists the character sets and collations supported by MySQL, tells you how to set the character set/collation at the server level, etc.)

John ParkerJohn Parker

I've come here looking to modify the collation only for a specific column for it to be case-sensitive and not for the entire table or the database. Among the sleep download pc. Hope it helps someone looking just for this.

This query could be tried:

Not the answer you're looking for? Browse other questions tagged mysql or ask your own question.