TWideStringField data

[gregoryliss]

running the following query:

select '¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ' from dual;
yields:
¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿

using TWideStringField(Qry.Fields[0]).Value

ODAC 6.10.1.10 for Delphi 7
session.UseUnicode := True
NLS_LANG: AMERICAN_AMERICA.UTF8
Oracle Client and Server 10.2.0.1.0

Any thoughts?

Thanks in advance

[Plash]

Character set of text in the SQL property must correspond to the character set in the NLS_LANG parameter. So that you should change your NLS_LANG parameter to your Windows character set (for example, AMERICAN_AMERICA.WE8MSWIN1252), or set the text of SQL property in UTF-8 encoding.