甲骨文+插入时java编码问题

发布于 2024-10-09 13:28:37 字数 788 浏览 3 评论 0原文

我有点被这个问题困住了。我不是java或oracle专家，所以请给出详细的答案:)

我有一个网络服务，可以将一些东西插入数据库。 Web 服务托管在 axis 上。数据库是oracle，具有以下属性：

NLS_LANGUAGE    AMERICAN
NLS_TERRITORY   AMERICA
NLS_CHARACTERSET    ZHS16GBK

网络服务托管在Windows Server 2008，英文版上，但我已将系统的区域设置更改为中文，

现在插入后的数据存在编码问题并显示奇怪的字符，例如????，埃克斯克??

jws文件采用GBK编码。并且插入数据库的数据被硬编码在文件中[我们不是从请求中读取它]

[编辑] 只是一件事，将整个数据库更改为 utf-8 是不可行的，因为它有大量的表和数据

[进一步编辑]以使事情更清楚，

机器接受来自两个源的数据。基本上它被用来向我们的订阅用户发送和接收短信/彩信。主要是与 GSM 运营商控制中心一起运行，所有编码均以 GBK 进行处理。另一方面，该机器还接受网站的请求，向用户发送短信/彩信。这里的编码是用UTF-8处理的。如果网站想要向用户发送短信，它将调用本机上的 Web 服务，该服务会将数据插入数据库[我们的问题就在这里]。然后Windows服务不断检查数据库，如果发现任何新的发送短信/彩信的请求，它将发送短信/彩信并删除记录。

旧机器上一切正常，因为它有中文版的 Windows 2003。我们升级到新服务器并在其上安装了 Windows 2008 服务器英文版。现在，Web 服务插入数据库后数据会失真。

原文

I am kind of stuck on this one. im not a java or oracle guru, so please give detailed answers :)

i've a web-service that inserts something into DB. the web-service is hosted on axis. the db is oracle with following properties:

NLS_LANGUAGE    AMERICAN
NLS_TERRITORY   AMERICA
NLS_CHARACTERSET    ZHS16GBK

the web-service is hosted on windows server 2008, english version but i have changed the locale of the system to chinese

now the data after insert has encoding problem and shows strange characters like ????,exxk??

the jws file has GBK encoding. and the data that is inserted into the DB is hard-coded in the file [we are not reading it from REQUEST]

[edit]
just one thing, its not feasible to change the whole DB to utf-8 as it has lots of table and data

[further edit] to make things more clear

the machine accepts data from two source. basically it is being used to send and receive sms/mms to our subscribed users. primarily, it operates with the GSM operator control center where all encodings are handled in GBK. On the other hand, the machine also accepts requests from the website to send sms/mms to the users. Here the encoding are handled in UTF-8. If the website wants to send a sms to the user, it will invoke a web-service on this machine which will insert data into db[our problem is here]. then a windows service continously checks the DB and if it finds any new request to send sms/mms, it will send the sms/mms and delete the record.

everything was working fine on the old machine as it had chinese version of windows 2003. we upgraded to a new server and installed windows 2008 server english version on it. and now the data is distorted after the web-service inserts into DB.

分享到QQ

分享到微博