Chinese support

[aisa]

Hi,

I tried to find a solution to my problem and could not find it in the forums. So sorry, if I am asking again.

I have to have my app display and edit chinese characters (simplified chinese). My setup is...

Database : Oracle 10g
NLS_CHARACTERSET => AL32UTF8
Client : Oracle92
DOA : 4.0.7
PLSQL Dev: 7.1
Delphi : 6
Controls : TNT Controls
Font.Name = SimSum (tried Arial Unicode also)
Font.Charset = GB2312_CHARSET
Windows : 2000

I can query and edit data successfully using PLSQL Developer. So I guess the database and my regional locale settings should not be a problem.

Now I create a new delphi app, I add OracleSession, OracleDataSet and DataSource components. Connect all, set query. BytesPerchar is Autodetect. Drop TNTGrid TNTLabel TNTEdit but the characters come up wierd.

eg 明天 雷阵雨 comes up ?? ???

What am I missing? Thanks in advance

Aisa

 

[aisa]

Also if I copy paste text in the tnt controls it shows fine. Thanks

 

[aisa]

DB as mentioned is AL32UTF8

What do I have to set the NLS_LANG registry entry to for chinese to show up correctly and I can also enter it.

Can you point me some good documentation?

Thanks

 

[aisa]

I am putting this as questions pop up in my head. How does PLSQL developer display those characters and enter them correctly. Maybe I can use that roadmap to setup my app.

Thanks in advance.
Aisa

 

[Marco Kalter]

PL/SQL Developer uses Direct Oracle Access 4.1, which supports Unicode character sets like AL32UTF8.

For Direct Oracle Access 4.0 you will need to use an explicit Chinese character set on the client, so that all UTF8 characters from the database are converted by Oracle Net.

 

[aisa]

Thanks. Any recommendation as to what NLS_LANG charset to setup in the registry. I tried a lot but they do not work.

Aisa

 

[Marco Kalter]

I don't know (I'm not Chinese ). You need an Oracle character set compatible with 明天 雷阵雨.