Devart Forums

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

no one reply me~~~~

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

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.

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