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?
