Extra linefeed on Orace string field

[jaska45]

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

[Plash]

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