UTF8 -character encoding
I have a problem showing other characters encoding besides english. i am using OLITE_10.3.0.2.0 and the repository in on a oracle 11g db.
the oracle 11g is configures to utf8 encoding during its installation and i can see the characters correctly of non english in char fields through my sql developer.
but when i synchronize my oracle client to my oracle server, the data that come are shown in ? and not in the correct characters. i have tried this
through my win32 oracle lite client and through my wince oracle lite client on a handheld.
in both clients the polite file has the DB_CHAR_ENCODING=UTF8 and no other setting for language.
in the server the polite.ini file has the DB_CHAR_ENCODING=UTF8 too.
the win 32 client is on windows pc that has the language installed, and this is the reason after all that i can see the characters through my sql developer. in my handheld wince client i can use the language characters in all other programs normally.
i have seen the characters that are shown as ? from the msql utility in both clients and from my own c# code.
what must i do in order to properly activate the utf8 in both oracle lite server and client in order to be able to access the characters from the repository?the DB_CHAR_ENCODING=UTF8 doesnt seem to do anything at all...
thank you for your time and efforts