Post reply

query complressed column?

  • April 1, 2012 at 12:33 pm

    #255867

    i have a table in a sql server 2008 server that has compressed data in several columns

    how do i query and view/display that data?

    for instance,

    select orderno, shipdate, otherdata from orders

    where shipdate > '20111231'

    the orderno and shipdate are not compressed and display fine..... the data in the otherdata column is compressed and either doesnt display at all (mgmt studio), or displays 'junk' characters (in some other query tools)

  • April 1, 2012 at 1:16 pm

    #1467452

    Are you sure you that these columns are compressed? I would rather guess that the data is encrypted. If so, you could ask the developers for the encryption key, but I would not count on getting it.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply