Devart Forums

Hi,

I have a table in Oracle database. The table has NVARCHAR2 field that contains string data. When I use TUniQuery to read the data a line feed character (#$A) gets inserted in the middle of the string. For example if I have 'This is a sample' value in the table I get "This is '#$A'a sample' when I call the following code:

query.FieldByName('MyValue').AsAnsiString;

If I use Oracle's admin tool to view the table contents there is not line feed characters.

I use Delphi 2009 and Oracle Database i10 Express Edition.

What might be the problem?

Best regards,
Jaakko

Probably the line feed character is contained in your table. But Oracle admin tool doesn't show it.