TUniQuery.SQL.Text AND UTF8

[Quido]

Hello,

I have problem with text of SQL command with UTF8 characters

- When passing UTF8 characters only by parameters, it's OK.
- When UTF8 characters are placed directly in Text property, they have been lost and question marks are sent to Oracle.

Is it lost by UniDAC, Delphi or Oracle OCI? Have you any idea how send they correctly?

win8, Delphi XE5, UniDAC 5.2.5, Oracle 12 instant client

Code: Select all

SpecificOptions.Values['UseUniCode']      :='True';  // only for data from Oracle

Example of UTF8 characters:
☃ Snowman ☃ U+2603
❄ Snowflake ❄
❅ Tight Snowflake ❅
❆ Heavy Snowflake ❆
... or everything in azbuka like было.

Thanks in advance

[AlexP]

Hello,

To make such query work, you should set the UseUnicode option and UnicodeEnvironment to True.

Code: Select all

  UniConnection1.SpecificOptions.Values['UseUnicode'] := 'true';
  UniConnection1.SpecificOptions.Values['UnicodeEnvironment'] := 'true';

[Quido]

Hello,

I have set specific option 'UnicodeEnvironment' to True but nothing changed - still question marks.

Is it effective in UniDAC 5.2.5?

[AlexP]

Hello,

You are using an obsolete UniDAC version. Try to reproduce the problem on the latest trial version: https://www.devart.com/unidac/download.html .

[Quido]

Hello.

I tried UniDAC 6.1.12 and sending UTF8 characters seems OK

Thanks

[AlexP]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.