Binary Datatype retrieval in Access 2000

K

Ken

I have a SQL 2000 Database with a Table that has two (2)
Fields of a BINARY Datatype. When I preview the data in
either Access 2000 or in SQL Analyizer, I can only see the
ascii reprentation of the binary data. Does anyone know
how to convert this or to view it in standard ascii or
text format?
 
S

Sammy Swen

Ken wrote in message said:
I have a SQL 2000 Database with a Table that has two (2)
Fields of a BINARY Datatype. When I preview the data in
either Access 2000 or in SQL Analyizer, I can only see the
ascii reprentation of the binary data. Does anyone know
how to convert this or to view it in standard ascii or
text format?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Binary Squares 3
Insert Binary Data with APOSTROPHE 7
Extracting Image datatype content with SQL2005? 23
How to convert binary or hexa to decimal? 2
Convert Binary Data to ASCII 6
Text to binary 5
SQL query is not working for Binary data!! 2
How can I view binary data in access 2

Top