Author: email@example.com (uniface8)
Hi all, we have a problem with some characters (like Ñ) in our database (oracle 10g) we have the following configuration:
NLS_LANGUAGE = SPANISH
NLS_LENGTH_SEMANTICS = BYTE
And in our asn files
in windows pc client $DEF_CHARSET=CP1252
in linux server $DEF_CHARSET=UTF8
The connection between clients and server is TCP
The server returns:
Server: I/O function: S, mode: 0, on file/table: TEST_TABLE index: 1 >=
Server: Where ((FIELD = 'SB14<C3><@1>'))
We know that is a problem with multy-byte / single-byte, we tried to change $DEF_CHARSET and mapping in [META_WESTERN] but not work.
A solution could be change NLS_CHARACTERSET in our database, but someone knows an alternative option?