Hi, > I've already made huge tables without using any 'ignorecase=true' > tags. Now, i want my tables to be case insensitive. What's the process > to do this?
You will have re-create the database. I suggest to use the SCRIPT statement or tool, then change the SQL script, and then use the RUNSCRIPT statement or tool. > is IGNORECASE = TRUE applicable only to 'varchar' > type? Not to 'char' ? Yes. Columns with type CHAR are always case sensitive. I suggest not to use CHAR for new applications. CHAR is only supported for compatibility with very old applications. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
