Re: Create case insensitive table from case sensitive table

[Brian]

SET IGNORECASE kinda appends _IGNORECASE for new CREATE TABLE column datatypes, since you did a CREATE TABLE AS SELECT and the old table had pre-existing VARCHAR (as opposed to VARCHAR_IGNORECASE) columns, they retained the case sensitivity from the original table.

On Sunday, September 9, 2012 6:26:41 PM UTC-7, rpw wrote:

How do I create a case insensitive table from a table that is case sensitive?

I tried the following:

SET IGNORECASE = TRUE;
CREATE TABLE new_table
  AS (SELECT * FROM old_table);

but the new table was case sensitive.
What am I missing?