Hi, There is no case-insensitive SQL type, so changing SimpleResultSet might be tricky / might not work.
I did not test this, but would this work for you (without patch): SET COLLATION ENGLISH SECONDARY Regards, Thomas On Mon, Mar 23, 2015 at 9:26 AM, <o.vanderm...@xso.nl> wrote: > Hi Fred, > > Thanks for your patch. I have tried to patch it it in my version of > SimpleResultSet, but it still orders not as expected. > I have run it in de debugger and the line: column.sqlTypeName = > "VARCHAR_IGNORECASE"; is executed. > the next line: column.sqlType = DataType.getTypeByName( column.sqlTypeName > ).sqlType; always set column.sqlType to the value 12, It does not matter if > I set ignorecase to true or false. > > Perhaps I did not patch it right and could you send the complete > SimpleResultSet.java? > > Olaf > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
