Re: [GENERAL] Case sensitivity

[Dev Kumkar <devdas.kumkar@xxxxxxxxx>]

On Thu, Dec 12, 2013 at 12:47 PM, Dev Kumkar <devdas.kumkar@xxxxxxxxx> wrote:

+ hackers

On Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar <devdas.kumkar@xxxxxxxxx> wrote:

On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar <devdas.kumkar@xxxxxxxxx> wrote:

Actually for searches lower will work.

But the other important aspect is 'inserts' which would result 2 rows if the values are 'A' and 'a'. Intent here to have it case insensitive.

If CITEXT it will update the same row and works.
CITEXT is an alternative but was wondering if there is any other alternate solution/setting while creating database.

Also does CITEXT fetch via JDBC works the same way as fetch/set string values? Any quick comments here.
http://techie-experience.blogspot.in/2013/04/hibernate-supporting-case-insensitive.html

Regards...

Also if the key columns are CITEXT is there any performance issues on indexes?

I am ok with CITEXT but for changing the database design for the primary/foreign key columns to be CITEXT need some suggestions/comments regarding performance for inserts/reads.

Awaiting...