#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Posts
    54
    Rep Power
    11

    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.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    138
    Rep Power
    12
    why don't you post the link to the microsoft example.
    --

    ngibsonau
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Posts
    54
    Rep Power
    11

    sql code


    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
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    138
    Rep Power
    12
    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
    --

    ngibsonau
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Posts
    54
    Rep Power
    11
    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.

IMN logo majestic logo threadwatch logo seochat tools logo