Disabling "Unicode Compression" property by SQL Query ( Access )

Is it possible to have a SQ开发者_JS百科L statement in Microsoft Access that can disable the unicode compression property on a column ?

Something in the lines of :

ALTER TABLE MyTable 
ALTER COLUMN MyColumn DISABLE UNICODE COMPRESSION

---

Yes. You simply need to omit the WITH COMPRESSION keywords when you call your alter statement. Thus, the following would add Unicode compression:

ALTER TABLE [Table1] ADD COLUMN Col1 TEXT(100) WITH COMPRESSION NOT NULL;

If after executing the above, you turned around and executed the following:

ALTER TABLE [Table1] ALTER COLUMN Col1 TEXT(100) NOT NULL;

It would remove Unicode compression.