Hot answers tagged casesensitive
7
by default, MySQL does not consider the case of the strings
This is not quite true. Whenever you create database in MySQL, the database/schema has a character set and a collation. Each character set has a default collation; see here for more information.
The default collation for character set latin1, which is latin1_swedish_ci, happens to be ...
5
You always should state with your question which version of MySQL you're using, because MySQL is in steady development.
Okay, back to your question:
The string functions in MySQL are always case sensitive, so you could
use any of the functions LOCATE, POSITION, or INSTR.
For example:
SELECT phone FROM user WHERE POSITION('term' IN user_name)>0;
...
3
You chose a case sensitive collation when installing SQL Server
You will have "CS" in this result:
SELECT SERVERPROPERTY('Collation')
You either live with it or rebuild the master database
2
Just altering the lower_case_table_names setting isn't enough. It needs to be done before you import your database(s).
The MySQL 5.1 documentation lists a procedure for moving between Windows and Linux/UNIX. This will ensure that your desired rules for enforcing case sensitivity are followed. Take a look and verify that you did these steps in the correct ...
1
Try adding this to a PropertyGroup in the .sqlproj file directly:
<ModelCollation>1033,CI</ModelCollation>
I had a similar issue when was migrating a .dbproj to a .sqlproj. I had this suggested to me by our team's dba, I don't know exactly what this does..
1
In oracle it is possible since 10.2. Take a look here Case-Insensitive and Accent-Insensitive Linguistic Sorts,so you might want to take a look again, 8i is a while ago now ....
1
I ended up writing some code that transforms the SQL generated by the application into PostgreSQL-compatible SQL. It's pretty straightforward:
Split the statement into sensible tokens, skipping single-quoted string literals
Double-quote anything that is not a keyword or number
I also took advantage of this layer to transform calls to isnull to coalesce. ...
1
Is there a way to set up PostgreSQL to disable this automatic case folding for database object identifiers?
Not directly. You might be able to make a relatively minor change to the PostgreSQL source code, and recompile it. (Start in src/backend/parser/parser.c?) But I'd be surprised if it were very simple.
Only top voted, non community-wiki answers of a minimum length are eligible
