ALTER COLUMN WITH COMPRESSION not working
Posted on 2008-06-12
Hi all experienced programmers,
I have created a table in code that has a text column, but I realized later that I wanted it to have Unicode Compression set to yes. I have users that are already running my program, and therefore they already have this column created in their table. I tried to alter the table (which contains data) for my next release using the following code:
with MyQuery do
SQL.Add('ALTER TABLE MyTable ');
SQL.Add('ALTER COLUMN Name CHAR(25) WITH COMPRESSION');
However, the Unicode Compression for the Name column is still set to NO. What else should I try?
I also don't know how to set 'Allow Zero Length' to NO.
Your help is much appreciated.