Hello every one, I'm in the process of porting an application from HSQLDB to Derby. I ran into an issue with defining unique constraints on character (CHAR and VARCHAR) data IGNORING the case. HSQLDB has a proprietary data type called "varchar_ignorecase" and we have used that extensively. However, there is no such thing in Derby that could find. So my questions are:
Is there a way to create a unique constraint/index which ensures the uniqueness of data IGNORING the case? What I mean by above is - trying to insert "derby" when "Derby" already exists in the table should produce a constraint violation error. I've gone through the documentation and Googled for several hours, but could not find anything to accomplish this. If there is no direct way to do this, what would be the best alternative/workaround? Any help would be greatly appreciated. Regards, Sai Pullabhotla President jMethods, Inc. Phone: +1 (402) 408-5753 Fax: +1 (402) 408-6861 www.jMethods.com
