This content has been marked as final. Show 5 replies
To know how Oracle is coding and storing data use the DUMP function.
One thing for sure ... Oracle is not storing question marks ("?") so this is most likely an issue of operating system character set rather than database character set.
SELECT DUMP(<column_name>) FROM <table_name>;
Please, describe the environment properly. How do you access the database? What tool? What Oracle access API? What client operating system?
Oracle does client/server conversion automatically and you should not have to convert anything explicitly, if the setup is correct.
The language in oracle is TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950.
I think it is the different between client and server, the operation system in client is windows, and its
setting is not TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950.
Is it possible to convert these character setting by sql? The API I used and developed is asp c#.
## The API I used and developed is asp c#
This is the programming API. What is the database driver/API below this programming API that is used to connect to the database. Is it ODP.NET or something else?
I think it is. I developed a API under a local system, and its db is oracle.