> 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@...>
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