sql unicode compression
Can anyone give me an example of how to set a field's unicode compression attribute using ASP because I've tried and tried and I always get a database error in my SQL statement even when I copy the SQL code directly from MSDN. Thanks.
why don't you post the link to the microsoft example.
This is the SQL statement that I'm trying to execute. I copied this from MSDN's Intermediate Microsoft Jet SQL for Access 2000.
ALTER TABLE tblCustomers
ALTER COLUMN LastName TEXT(255) WITH COMPRESSION
Did you do it using vb or vbscript code or did you do it in Access SQL View???
Second if all above is in order what version of driver are you using?
Microsoft Jet 4.0 database engine
I'm using vbscript code and jet driver version 4.0.
Also, if I take the unicode compression clause out it works fine as written.