Re: Data type changes using ODBC...

From: Gerard H. Pille <>
Date: Wed, 24 Jun 2009 18:46:16 +0200
Message-ID: <4a425858$0$2870$>

Strange Cat _at_ Work schreef:
> Hello everyone,
> I am using Oracle ODBC to connect tables from an Oracle schema to an
> empty Microsoft Access DB.
> In one particular table i have a VARCHAR2 field that is 255 chars long.
> This field is reported as being of MEMO type in Access, which is untrue.
> Problem is that another third-party (that reads the Oracle data sw) has
> problems using Memo fields.
> Can anyone help me in forcing ODBC driver to report the field as TEXT in
> Access, as it should be?
> Paolo

Could it be that your NLS_LANG setting is referring to a multi-byte characterset? Text is max 255 characters, maybe the ODBC driver thinks you may need more. Received on Wed Jun 24 2009 - 11:46:16 CDT

Original text of this message