TOraXMLField and Unicode

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gregoryliss
Posts: 13
Joined: Mon 19 Dec 2005 16:31

TOraXMLField and Unicode

Post by gregoryliss » Fri 15 May 2009 19:12

ODAC 6.70.0.42, Delphi 2009, using a TSmartQuery, the Session.UseUnicode = true. Using the following SQL:

SELECT XMLELEMENT ("测试", dummy) "网页测试" from dual

When retrieving the value using TOraXMLField(dsField).AsString, the result is:

X

where the results should be:
X

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 18 May 2009 09:51

ODAC do not support Unicode in XMLTYPE.

Post Reply