query and display compressed data?

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)
jimwarrenusAsked:
Who is Participating?
 
Deepak ChauhanSQL Server DBACommented:
Hi Dear...

            please check select permission on this table it may be possible u dont have permission on 'otherdata column of this table.
                I don't think data compression is the reason of doesn't showing 'otherdata' column as i understand data compression can be two type row level or page level if two column is showing from this table which is also part of complete row and if we are talking about page level then page is also stored data in row format.

you can test this with (select * from order) if you dont have full select permission then query will through an error....
0
 
jogosCommented:
Is it compressed by SQL Server?

Can you post the table definition.
0
 
jimwarrenusAuthor Commented:
i finally heard from the developer and turns out they also refer to it as "packed"....<br />this solved the problem:<br /><br />SELECT CAST(CAST(SUBSTRING(BIGDAT<wbr />A,1,4)AS VARBINARY) AS BIGINT)<br />FROM PROCESSING
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.