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!