Korean Characters

[ccwillia]

I need to be able to enter chinese, korean, and english characters into my oracle database. I have spoken with my DBA and the database is setup for UTF-8. I have tried downloading a Korean font and then changing the font in the preferences, but still have had no sucess. Can someone please help me out? Thx

 

[Marco Kalter]

You will need to select the correct font and character set for the grid font in the preferences, and you must also select the matching character set for Oracle Net (NLS_LANG) for the primary oracle home.

 

[ccwillia]

I have changed the grid font but the characters still show up as "?" in PL/SQL Developer?

 

[ccwillia]

I have changed the font for the browser, grid, and editor to Dotum (Script Hangul). When I copy and paste the characters from windows character map into the sql window I get the "?".

 

[ccwillia]

Can someone please help me out on this I have changed all the fonts in PL/SQL Developer to Dotum and the script is Hangul. I have gone into the windows characters map and selected the Dotnum font and selected a korean character, but when I try to paste it in PL/SQL Developer it becomes a "?" question mark.

Thanks,

CW

 

[Marco Kalter]

Does this problem only occur when pasting text? Do you see the correct characters when you query text from the database?

 

[ccwillia]

The test is not in the database yet. I need to be able to type the characters to insert it into the database.

Thanks

CW

 

[Marco Kalter]

But what happens if you do insert the text into the database (with PL/SQL Developer or SQL*Plus)? Does it show up correctly if you subsequently query it in PL/SQL Developer?

 

[Natalya]

I have exactly the same problem. If I try to type in or paste Korean characters, I get question marks.
How do one "select the matching character set for Oracle Net (NLS_LANG) for the primary oracle home"?

Thanks

 

[Marco Kalter]

If you type korean characters you get question marks? That would indicate that you need to go to Tools > Preferences > Fonts and select a korean character set for the corresponding font (depending on where you typed your text).

 

[Natalya]

Yes, I get question marks even though I have Fonts set correctly in the Preferences. What I didn't set is the NLS_LANG attribute. Where and how do you set it?

Thanks

 

[ccwillia]

I think the NLS_LANG is on the ORACLE side, but the editor should be able to display korean characters, but it doesn't seem to work.

 

[Marco Kalter]

If the editor does not display the korean characters, then I can only assume that the character set of the editor font is not defined correctly. The NLS settings are not yet involved at this level, it's strictly an editor font/character set issue.

 

[Natalya]

Hmm, I am pretty sure I've set Fonts in Preferences correctly. I selected Gulim as the font and Hangul as the script in Browser, Grid, and Editor settings. Is anything else required?

It's interesting to note, that the English characters of the Gulim font display just fine. I can also type/paste Korean in other applications (such as Word) on my computer.

Is it possible that Korean support doesn't work for Version 5.1.0.657 (MBCS) of PL/SQL Developer that I am using on Windows 2000 version 5.0 (build 2195) Service Pack 4?

Could anyone please test Korean for this set up.

Thank you.

 

[gulhaugen]

Works fine for me. Now, what info do you need?
I have UTF-8 in the database.
Did not change ANYTHING else than the font, (and I previously used norwegian characters fine).
Using plsql 5.1.6.747

 

[Natalya]

Thanks. Could someone please check Korean support on Version 5.1.0.657 on Windows 2000
or better yet, can Allround Automations team confirm that it works for Version 5.1.0.657 on Windows 2000?

Thanks.

 

[ccwillia]

I have version 5.1.6.747 and I still get question marks. Gulhaugen please explain exactly what you changed in the fonts and what font type you used.

Thanks,

 

[gulhaugen]

Tools->Preferences->Fonts->Grid->Select Font.
I downloaded the font GulimChe.ttf from
ftp://ftp.bentley.com/pub/tools/ttf/GULIM.TTF

Thats it.

 

[Natalya]

Thanks for the help, but it still doesn't work. I tried different fonts and I still get question marks.
Marco Kalter, or anyone else on Allround Automations team, have you tried it on Windows 2000? What about Version 5.1.0.657?

Thanks

 

[Stephen Li]

I've also encountered a similiar issue. Chinese characters display incorrectly in the query result spreadsheet in Pl-sql. I've installed all language packs and most Chinese fonts. Please help! Thanks a lot.