Problem to display Portuguese and Chinese with Net=True in Unicode DB.

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
akiraiu
Posts: 22
Joined: Tue 16 Nov 2004 02:31

Problem to display Portuguese and Chinese with Net=True in Unicode DB.

Post by akiraiu » Sat 13 Aug 2005 09:28

Settings are following:
ODAC 5.55.0.21
Delphi 7.1
Oracle 9i 9.2.0.5.0 with (charset = AL32UTF8 & NLS_LENGTH_SEMANTICS=CHAR)
OraSession Options (Net = True, UseUnicode = True)
TntUnicodeControls (download from http://www.tntware.com/delphicontrols/u ... nloads.htm)
(chinese or english) Windows XP Professional SP1 (Control Panel->Regional and Language Options->Regional Options->Chinese (Taiwan))

I already have some data that contains portuguese and chinese in Unicode DB table.
when I set the Regional Options to "Chinese (Taiwan)",
the chinese display fine, but some portuguese can not display.

when I set the Regional Options to "English (United States)",
the portuguese display fine, but the chinese can not display.

how can I display the Portuguese and Chinese successful with Net=True and Regional Options->Chinese (Taiwan))?

Akira

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Sat 13 Aug 2005 20:20

Possibly this is a problem of visualization in VCL components. Because ODAC returns the same data for Chinese and Portuguese independently from Regional Options. Try to test TStringGrid or TEdit with constant data. Try to use some controls ("Tnt Delphi UNICODE Controls" for example) that can work with Unicode directly.

akiraiu
Posts: 22
Joined: Tue 16 Nov 2004 02:31

Post by akiraiu » Sun 14 Aug 2005 05:05

I already used "Tnt Delphi UNICODE Controls", but also have this result when I changed the Regional Options ["Chinese (Taiwan)" or "English (United States)"].

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 15 Aug 2005 07:47

We reproduced your problem and fixed it. This fix will be included in the next ODAC build.

akiraiu
Posts: 22
Joined: Tue 16 Nov 2004 02:31

Post by akiraiu » Mon 15 Aug 2005 08:19

Thanks, wait for next build. :lol: :lol:

Post Reply