+ 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? >
