Problem with spanish characters
731375Oct 31 2009 — edited Oct 31 2009Hello
I am using an existing and proven app written in visual foxpro with a recently installed Oracle11g database (have done this before without problems)
I am using Microsoft ODBC for Oracle and have no possibility of changing this. (always used this without problems)
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. Language is Spanish.
Some settings that the Oracle DBA passed to me are
NLS_CHARACTERSET = AL32UTF8
NLS_NCHAR_CHARACTERSET= AL16UTF16
Any help will be appreciated, thanks!