Isa Karbstein wrote:
Hi NG,
we are using MS-Access 2002 as a frontend for Oracle Databases versions 8i
and 10g. Now I have a problem with the connected tables of the 10g database.
In Access all text fields are shown with a wrong fieldsize. (e.g.
Varchar(10) is shown as Text(30) in Access).
The connected tables of the 8i database are correct.
I am using the Oracle ODBC driver version 9.02.00.00.
Does anybody know this problem?
Thank you for your help
Isa
I had same problem like you.
You must check your database parameters with query:
select * from nls_database_parameters
Check parameters NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET.
Certainly, one of those parameters is UTF8 or UTF16. (on 10g db)
Regardless of Text(30) in Access you can NOT insert data length>10,
because you used linked table, not access table.
About UTF8, You can find more information on metalink.oracle.com
I replaced both NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET to
(EE8MSWIN1250) and solve my problem.
--
Gox