I meet a trouble when input data to Database in programming.
I try to input a traditional chinese word to db, however, when the data be
input to db , it shows '?'. After checking the db lang setting like:
select userenv('language') from dual
it shows TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950;
It seems to solve the problem I need to convert the string to TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950 in SQL.
Is that possible to make that, thanks a lot.
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?