Re: ODBC Oracle Access and Raw problem

In article <3a1050e8$1_at_rpc1284.daytonoh.ncr.com>,   "Jeff Siegel" <js1111_at_yahoo.com> wrote:
> I can't get Access to read a raw(16) type from Oracle 8i into a usable
> format.
>
> It looks like Oracle's ODBC driver sends RAW fields to Access as
 Binary
> types.
> These "binary types" are not really useful in Access. A type of TEXT
> would be more suitable. Ideally I'd like that field to show up as
 TEXT in
> Access.
>
> I think this stuff came across as TEXT with Oracle 7.3, but I'm not
> positive.
>
> Is there a way to do this? Or is this just Microsoft and Oracle not
 wanting
> to talk to each other?

I'm not sure that the behavior you describe is incorrect. My understanding is that the RAW data type is intended for use when you have raw binary data that needs to be stored. I don't believe it's possible for us to convert this data into text, since we don't know the encoding scheme, or even that the data has a logical mapping to text. I'd tend to say that the fact that Access won't display raw binary data is a limitation of Access.

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.