On Thu, Dec 12, 2013 at 12:47 PM, Dev Kumkar <devdas.kum...@gmail.com>wrote:
> + hackers > > > > On Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar <devdas.kum...@gmail.com>wrote: > >> On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar <devdas.kum...@gmail.com>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...