On 31 Aug 2007, at 08:39, piraju1379 wrote:

> Firebird 2.0.1
>
> Using isql to execute one script test.sql
> isql -i test.sql
>
> */test.sql*/
> INSERT INTO Table1 (Field1)
> VALUES ('Line1
> Line2');
>
> Isql exchange CR+LF for LF.
>
> Executing script test.sql in the IBExpert not
> the problem occurs.
>
> Would be one bug of isql or exists some configuration?

It is usually a better idea to make the characters explicit. From
the Firebird Book, p162:

INSERT INTO Table1 (Field1)
VALUES ('Line1' || Ascii_Char(13) || Ascii_Char(10) || 'Line2');

HTH,
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html