Acess & Oracle Unicode Problem

From: Dave (anonymous_at_discussions.microsoft.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 08:16:02 -0700

Hi All,

I am accessing an Oracle database via Acess using an ODBC DSN.
All is fine until I access a particular field whose data type is described in the linked Oracle table as Memo.

My query includes other Memo fields but they are extracted correctly.
When the problem memo field is queried I get an error message :
'The width of a Unicode text column must be an even number of bytes'.

Any idea if there is a problem with the data or is it my means of accessing the Oracle Database?

I am new to Oracle via Access...Any Ideas?

Thanks,
DaveD

Relevant Pages

  • Re: how to get datatype of columns of a table in perl script
    ... I am developing perl script which connects to oracle database and selects rows from a table and then inserts them into its corresponding table in db2. ... Any database should be able to handle this regardless of the data type. ... A great introspection feature. ...
    (perl.dbi.users)
  • date_format
    ... I have some data in an oracle database which has a data type of DATE and the ... work with an Oracle thin client. ... there a standard date setting you can change so everything outputs with the ...
    (alt.php)
  • Re: how to get datatype of columns of a table in perl script
    ... >>which connects to oracle database and selects rows from a table and then ... > A simple generic solution is to just quote all literal values, ... > this regardless of the data type. ...
    (perl.dbi.users)
  • MS Access to Oracle via ODBC
    ... All is fine until I access a particular field whose data type is described in the linked Oracle table as Memo. ... My query includes other Memo fields but they are extracted correctly. ... When the problem memo field is queried I get an error message: ... Any idea if there is a problem with the data or is it my means of accessing the Oracle Database? ...
    (microsoft.public.data.odbc)
  • RE: Errors while inserting into long data type
    ... > Hi Friends, ... > I am using oracle database and I have column of long data type. ... Ronald ...
    (perl.dbi.users)