MS Access unicode compression

[Gricehead]

Using both CF 5 and 6 with MS Access 2002 as the database.

Trying to create and maintain tables through a ColdFusion app, and running
into problems because every text column I create has the Unicode Compression
tag set to No.

Microsoft suggest using "With compression" as part of the alter column (or
add column) statement
([url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/a[/url]
cintsql.asp) but this doesn't work.

Any ideas how I can do this, to save having to take the database down
everytime I want to add a column?

[Mountain Lover]

this works on the CFMX 6.1 server I'm on using the MS Access w/ unicode
driver, Access 2000

LAST_NAME CHAR(25) WITH COMPRESSION NOT NULL,
FIRST_NAME CHAR(20) WITH COMPRESSION NULL,

HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[Gricehead]

Originally posted by: Newsgroup User
this works on the CFMX 6.1 server I'm on using the MS Access w/ unicode
driver, Access 2000

LAST_NAME CHAR(25) WITH COMPRESSION NOT NULL,
FIRST_NAME CHAR(20) WITH COMPRESSION NULL,

HTH


Tim,
Not working for me I'm afraid:

Your database query:
alter table test modify column second char(50) with compression null
Failed. The SQL return codes were:
SQL State: 42000
Native Error Code: -3554

I noted you mentioned a specific driver. Could this be the issue?

Colin

[Mountain Lover]

Yeah, you need to use the unicode driver because it uses OLEDB.
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]