Re: How to make copy of table case insensitive?
20 views
Skip to first unread message
Brian
Sep 17, 2012, 7:45:26 PM9/17/12
to h2-da...@googlegroups.com
Change the datatypes in the new table to VARCHAR_IGNORECASE.
You can either copy as-is and then ALTER or you can create the new, empty table with the new structure and INSERT INTO SELECT FROM.
On Sunday, September 9, 2012 6:39:22 PM UTC-7, rpw wrote:
You can either copy as-is and then ALTER or you can create the new, empty table with the new structure and INSERT INTO SELECT FROM.
On Sunday, September 9, 2012 6:39:22 PM UTC-7, rpw wrote:
I have a table that is case sensitive.
I want to make a copy of the table and have the copy be case insensitive.
How do I do that?
Reply all
Reply to author
Forward
0 new messages