Case Insensitive

Jul 14, 2015 at 10:54 PM
Hi,

Is there any way to make a column case insensitive and accent insencitive directly in Vita Entities?

Regards
Jul 14, 2015 at 11:12 PM
can you pls be more specific? When comparing values in columns? or column names? and which server?
Jul 14, 2015 at 11:16 PM
When comparing value, using sql server.

If i change the Column to CI/AI i do not need to wory when i compare values in a query because SQL server does that automatically.

Regards
Jul 14, 2015 at 11:19 PM
what is CI/AI? and then i don't understand. MS SQL is already case insensitive, so it does this for you automatically
what you need instead?
Jul 14, 2015 at 11:22 PM
CI/AI = Case Insensitive / Accent Insensitive

João is not = to Joao

So if i change the column to Accent Insensitive it will return my required results.

Regards
Jul 14, 2015 at 11:30 PM
Found the correct name for it, Collation
Jul 14, 2015 at 11:45 PM
so what you ask is ability to set Collation on column from Vita; or even on entire database... you can set it for entire database when you create it - will that work? VITA assumes already existing database when it starts and gets a connection string, so if you pre-create it with collation you need, it might work for you
Jul 14, 2015 at 11:48 PM
I was just asking to see if it was possible, i can do it at database level.

Thanks
Jul 14, 2015 at 11:55 PM
I will look at it, it is not supported currently but I may provide it in the future, does not seem to be too difficult