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-5-20 19:30 | Show This Author's Posts Only
abstract:

Thanks.


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.

TOP

Rank: 1
2#
ngibsonauPost at 2010-5-20 19:30 | Show This Author's Posts Only
why don't you post the link to the microsoft example.

TOP

Rank: 1
3#
dirtybbqPost at 2010-5-20 19:30 | Show This Author's Posts Only
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

TOP

Rank: 1
4#
ngibsonauPost at 2010-5-20 19:30 | Show This Author's Posts Only

Note   The data types listed in the previous SQL statement can be executed only through the Jet OLE DB provider and ADO. They will result in an error message if used through the Access SQL View user interface. Also note that if you create a field with the TEXT data type through the Jet OLE DB provider and ADO, it will result in a data type of MEMO when you view the table design through the Access user interface.
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

TOP

Rank: 1
5#
dirtybbqPost at 2010-5-20 19:30 | Show This Author's Posts Only
abstract:

Thanks.


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.

TOP

Back Forum