>Hello
>In one new installation of my old and proven VFP app, using an Oracle 11g database via old MS Odbc for Oracle (as I have always done before) , I have this problem:
>
>If I insert a string in in a fixed length char field of the same length of the string (say char(30)) IF THE STRING DOES NOT HAVE SPECIAL CHARACTERS, everything goes as usual. However, if the string contains some spanish language chars (ó, é, á, ñ) the insert fails indicating that the string is too long. I suspect "somewhere" this characters are encoded in double-byte instead of single-byte.
>
>My question is, which is the Oracle setting that allows/prevents this? I need special characters encoded in 1 byte.
>
>Some settings that the DBA passed to me are
>
>NLS_CHARACTERSET = AL32UTF8
>NLS_NCHAR_CHARACTERSET= AL16UTF16
>
>Any help will be appreciated, thanks!
At this point, I would try the Oracle ODBC drivers specifically made for Oracle 11g. I always run into problems with the Microsoft ones.
Regards,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!