delphi programming forums mysql charset mget recursive synonimos
free ventrilo servers hosting cs javascript delay python find in list
Back Forum New

Rank: 1
1# Jump to »
dirtybbqPost at 2010-4-25 13:05 | Show This Author's Posts Only
abstract:

This is the specific query I am trying to run:
ALTER TABLE respones
ADD COLUMN testing TEXT(50) WITH COMPRESSION
Can anyone help? Thank you!


I am using CFML to run SQL queries on an Access 2000 database. According to all sources I've read including MSDN the way to enable unicode compression on string data types in Access 2000 through SQL is by using the WITH COMPRESSION or WITH COMP keywords. I have tried this to no end and it does not work. This is the specific query I am trying to run:
ALTER TABLE respones
ADD COLUMN testing TEXT(50) WITH COMPRESSION
Can anyone help? Thank you!

TOP

Rank: 1
2#
kruckerPost at 2010-4-25 13:05 | Show This Author's Posts Only
I had the same problem but used this and it worked. I am using an Access DB in VB 6 using ADO.
db.Execute ("ALTER TABLE ImportExport ADD EmailToName char(50)")
db.Execute ("ALTER TABLE ImportExport ALTER COLUMN EmailToName char(50) WITH COMPRESSION")
I tried it with one line and it didn't work... in too big of a hurry to screw with it... it works so, onward



This is the specific query I am trying to run:
ALTER TABLE respones
ADD COLUMN testing TEXT(50) WITH COMPRESSION
Can anyone help? Thank you!

TOP

Back Forum