Hello,

The I have saved the files in ANSI format in notepad.
If I try for example unicode or UTF-8 format isql -i command throws
EOF expected etc notice.

What format are others using in windows ? and I have learned that
script files ending with CTRL+F gets rid of those EOF messages at
least for ansi notepad files.

BR,

MariJo
--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

> > The problem is that when I insert data (strings) with isql script

and I have the setting SET NAMES UNICODE_FSS before

> the connection phrase. (I have written the script in windows

notepad)

>
> How are you saving the script from the notepad. As UTF-8 ?
>
> Ivan
>
>
>
> ----- Original Message -----
> From: "Mari Johanna" <marijoaou@y...>
> To: <firebird-support@yahoogroups.com>
> Sent: Thursday, September 30, 2004 11:53 AM
> Subject: [firebird-support] Unicode characters are dropped out

firebird 1.5.1 and .net provider 1.6.2 isql input

>
>
> Hello,
>
> I have a problem with unicode characters äåö etc that appeared

after I changed from 1.0.3 database version to database

> version 1.5.1 and newer .net provider.The problem is that when I

insert data (strings) with isql script and I have the

> setting SET NAMES UNICODE_FSS before the connection phrase. (I have

written the script in windows notepad)

>
> The data seems to be OK when I look at it with IBSQL and that

program shows the problematic characters allright. But

> when I query them with .net provider for firebird then all the

problematic characters are left out from the .net

> dataset.
>
> But when I use this same .net provider to insert this data as

unicode then this provider can get the datas without

> missing any ä:s and ö:s. And that is why it seems that there could

be something this isql script is putting is not OK.

>
> Would be really really grateful if anyone could help me with this

one. It is odd that everything was working just great

> before I upgraded to the newer versions of database and provider.
>
> BR,
> MariJo