Unicode Again

[Markus Pesti]

All my trails to get an unicode string via TOracleQuery.FieldAsString have failed. For example I tried 'StringToWideChar'. But the result is always a string like '

 

[Axl]

For Unicode Oracle has NVARCHAR2 data type. I tried a simple "insert into..." statement with TOracleQuery.SetVariable, but got "ORA-12704: character set mismatch". It seems that this data type currently is not supported by DOA.
No luck getting Unicode data into Oracle so far...

 

[Markus Pesti]

No, this error occurs if your database has not bben set up with an unicode character set.

But the problem with DOA is, in my opinion, that all string properties are String and not WideString.