Reading Sami characters (ȟ, ǩ, ǧ, ǥ, ǯ, ŋ) in xmltype field

[Norway]

Hello,

I have a problem with reading sami characters from (ȟ, ǩ, ǧ, ǥ, ǯ, ŋ) xmltype field.

I am using ODAC 6.90.0.52 for Rad studio 2010 with Oracle Universal 10g

SELECT * FROM PRIMUS.TMP_OBJECT_XML where objid=43

Here is What I get from SQLDEVELOPER
OBJID XML_DATA
----------------------------------------------------------------------------------------------------
43 57_TEST-11Enkeltverkt

ÁÂŽŠ€ĐČǤǮŦǦƷȟŊµÏǨÕÖÄPrimus

MUSEUM_NAVN>Museumsnavn43

ÁÂŽŠ€ĐČǤǮŦǦƷȟŊµÏǨÕÖÄ

1 rows selected

And here is What I get From TOraQuery.Toraxml

Query.SQL.text is
'SELECT * FROM PRIMUS.TMP_OBJECT_XML where objid=:objid'

code
...

Query.ParamByName('objid').AsInteger:=43;
Query.Open;
if not Query.EOF then
tempStr:=QueryXML_DATA.AsWiedString;
Query.Close;

...

'57_gj106ÁÂŽŠ€ÐCG¿TG¿¿¿µÏKÕÖÄanvendt

20102020AAREnkeltgjenstand¿¿¿¿¿¿¿¿¿tt€

€âââádggcc¿¿ÁÂŽŠ



€ÐCG¿TG¿¿¿µÏKÕÖÄPrimus

Museumsnavn'


I have tried it AsVariant , AsString.

NLS_CHARACTERSET AL32UTF8

I would appreciate any help to solve this problem.

[Plash]

ODAC does not support Unicode for XMLTYPE. Try to select value as CLOB:

Code: Select all

SELECT t.xml_field.GetClobVal() FROM PRIMUS.TMP_OBJECT_XML t where objid=:objid

[Norway]

I keep getting function not supported When I use GetClobVal()! What is Wrong?

[Norway]

Error starting at line 1 in command:
SELECT t.xml_field.GetClobVal() FROM PRIMUS.TMP_OBJECT_XML t
Error at Command Line:1 Column:7
Error report:
SQL Error: ORA-00904: "T"."XML_FIELD"."GETCLOBVAL": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:

[Norway]

Sorry ! My bad
It Works