1

I have a unique constraint on a String field in a table in my database and i was wondering if unique attribute in ormlite is case sensitive ?

For example, is "Bob Smith" and " BOB SMITH" the same thing for the unique constraint ?

Thanks for your answers and your help.

Mounir
  • 43
  • 3

1 Answers1

1

This is database dependent I suspect. You will need to check your database documentation to see how what it does. ORMlite doesn't do anything special with the UNIQUE SQL clause -- it just uses it.

For example, here's the answer for MySQL: SQL unique varchar case sensitivity question

Community
  • 1
  • 1
Gray
  • 115,027
  • 24
  • 293
  • 354