| Garbled foreign text in Oracle SQL Developer [message #624938] |
Mon, 29 September 2014 02:04  |
Eric Langager
Messages: 38
Registered: April 2004
Location: Beijing, China
|
Member |
|
|
Greetings,
I have installed Oracle 11g XE on my Windows 7 laptop. The problem is that when I try to do select statements from either PL/SQL Developer or Oracle SQL Developer, Chinese and Japanese text are garbled. Interestingly, if I export to a SQL script file, Oracle SQL Developer will create them correctly, but PL/SQL Developer garbles the text there, too. I should note that SQL Plus is NOT affected by any of this. Text always appears normally when I do select statements in SQL Plus. So obviously the text is being stored correctly in the database. It is clearly a client issue.
I have been told that I need to edit the language parameter in the registry. The current setting is AMERICAN_AMERICA.WE8MSWIN1252. The tech guy for PL/SQL Developer told me to change it to AMERICAN_AMERICA.UTF8. But when I did that, it was garbled even in SQL Plus. I had to do a system restore to get it back. My situation now is as follows.
1. I use SQL Plus for all DML stuff. No problems.
2. I use Oracle SQL Developer to back up my database. It creates correct SQL inserts. But I cannot use it as a display tool. SQL Worksheet garbles foreign text.
3. I can use PL/SQL Developer for DDL stuff, but it is pretty much useless for anything else (unless I am working with tables that do not have Chinese or Japanese text).
I should note that I changed the system locale to Simplified Chinese so that I could run non-unicode software in that language. But my operating system is English language Windows 7.
Any suggestions would be appreciated.
Eric Langager
1 select * from nls_database_parameters
2* where parameter like '%CHARACTERSET%'
SQL> /
PARAMETER VALUE
------------------------- ---------------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
|
|
|
|
|
|
|
|
| Re: Garbled foreign text in Oracle SQL Developer [message #625138 is a reply to message #624947] |
Wed, 01 October 2014 12:23  |
Eric Langager
Messages: 38
Registered: April 2004
Location: Beijing, China
|
Member |
|
|
Actually the NLS parameters are not related to my problem. The NLS parameters are designed to govern how error messages and so on are displayed. If you were using a Chinese computer and wanted the error messages to appear in English, you could do that by setting the NLS language parameter. For example, several years ago, I was teaching some Chinese students, and gave them a sample script that inserted some dates in a table. The script would crash on their computers until I showed them how to set the NLS date language to English.
My current problem is not related to this. My problem has to do with how my own data is displayed. It appears normally in the default SQL Plus utility without setting the NLS parameter (or anything else) But if I use a different client such as PL/SQL Developer or Oracle SQL Developer, the text is garbled.
|
|
|
|
|
|
|
|
| Re: Garbled foreign text in Oracle SQL Developer [message #625143 is a reply to message #625140] |
Wed, 01 October 2014 14:15 |
Eric Langager
Messages: 38
Registered: April 2004
Location: Beijing, China
|
Member |
|
|
|
That's correct. I also tried editing the registry. The thing I don't understand is that my settings were exactly the same when was handling the same data with Oracle9i installed on Windows XP. Now I have Oracle 11g XE on Windows 7. Could be something with the Win 7 operating system. I don't know. But the data itself is not corrupt, because it appears normally as long as I do select statements in SQL Plus using the default command window.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
