Re: Data type changes using ODBC...

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



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?
>
> TIA
> 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