Can not Display some portuguese char in Net?

akiraiu · Post by **akiraiu** » Wed 25 May 2005 01:27

hi,
My Test Environment:
ODAC5.50.0.18
Oracle 9i 9.2.0.5 (charset is AL32UTF8, NLS_LENGTH_SEMANTICS=CHAR)
Delphi 7.1
OraSession options : net := true, useunicode := true, charlength := 1
TntUnicodeControls
(unicode supported VCL, download here: http://www.tntware.com/delphicontrols/unicode/)

My problem is that, use tnt unicode controls with net options to connect to oracle and save Portuguese char, after save some portuguese can not display, but it can success to save the all portuguese (why I know it can success to save because I use JSP to test retrieve the data that can success to display in utf-8 web page)

On the other hand, when I no use net option to connect to oracle with tnt unicode controls display data, both save and display is success.

why use net options have that display problem?

thx
Akira

Guest · Post by **Guest** » Fri 03 Jun 2005 01:55

no one reply me~~~~

Paul · Post by **Paul** » Fri 03 Jun 2005 09:22

We cannot reproduce your problem with VARCHAR fields in
ODAC5.50.0.18, Oracle 9i 9.2.0.5 (charset is AL32UTF8, NLS_LENGTH_SEMANTICS=CHAR)
What results do you have with net=false? What type of field do you try to view? What characters do you try to insert?
Please check the result of expression TWideStringField(OraQuery1.FieldByName('FIELD')).Value; when net=false and net=true

akiraiu · Post by **akiraiu** » Mon 06 Jun 2005 01:07

Paul wrote:We cannot reproduce your problem with VARCHAR fields in
ODAC5.50.0.18, Oracle 9i 9.2.0.5 (charset is AL32UTF8, NLS_LENGTH_SEMANTICS=CHAR)
What results do you have with net=false? What type of field do you try to view? What characters do you try to insert?
Please check the result of expression TWideStringField(OraQuery1.FieldByName('FIELD')).Value; when net=false and net=true

hi,
I got the problem with net = true. When net = false without this problem.
The Field in Oracle is VARCHAR2.
And I have tried TWideStringField(OraQuery1.FieldByName('FIELD')).Value with net = true (not problem with net = false).
It is also cannot display some port. char.
And I tried the following port. char. (not just the following char.): çûîâ

Thanks.

Paul · Post by **Paul** » Fri 10 Jun 2005 08:41

We cannot reproduce your problem on the machine with Portuguese (Brazil) regioanl settings, ODAC5.50.0.18, Oracle 9i 9.2.0.5 (charset is AL32UTF8, NLS_LENGTH_SEMANTICS=CHAR), Delphi 7.1