[Firebird-net-provider] Should UNICODE_FSS charset work in Provider1.5?

[mailmur <ma...@ya...>]

I have a database with a global UNICODE_FSS (UTF-8 I
think???) character set. I can insert scandinavian
letters (åäö) in IBAccess and IB_SQL admin tools. Data
is displayed fine. I've cheched a column charset from
the system tables and its mapped to a right charset.

But then I have NETProvider1.5 test program, which
cannot read unicode characters but they are completely
dropped from the output string.

ServerVersion is "WI-T6.3.0.3773 Firebird 1.5 Release
Candidate 5" running on Win2k.

It should output CITY value as "Känkkäränkkä", but is
shown as "Knkkrnkk" :-(

[Table metadata]
CREATE TABLE Customers (
  id integer NOT NULL PRIMARY KEY,
  custno integer NOT NULL UNIQUE,
  name varchar(50),
  city varchar(15),
  balance numeric(12,3),
  custtype varchar(4),
  isactive varchar(1)
);

INSERT INTO Customers Values(1, 1001, 'Customer A',
'Känkkäränkkä', 12.456, 'SUA', '1');
INSERT INTO Customers Values(2, 1002, 'Customer B',
'Saiperia', 5.1, 'SUB', '1');

[Console testprogram]
using System;
using System.Data;

using FirebirdSql.Data.Firebird;

class MainClass {

 public static void Main(string[] args) {
  MainClass main = new MainClass();

        String connectionString =
"Database=testdb;User=SYSDBA;Password=masterkey;Server=localhost;charset=UNICODE_FSS;dialect=3";

     IDbConnection con =
main.createConnection(connectionString);
     IDataReader reader = null;
     try {
         IDbCommand command = main.createCommand();
         command.Connection = con;
         command.CommandText = "Select * From
Customers";

         reader = command.ExecuteReader();
         while(reader.Read()) {
             for(int i=0; i < reader.FieldCount; i++)
{
                 Console.Write(reader.GetString(i));
                 Console.Write(", ");
             }
             Console.WriteLine("");
         }
     } finally {
         if (reader != null) reader.Close();
         con.Close();
     }
 }

 public IDbConnection createConnection(String
connectionString) {
     FbConnection con = new
FbConnection(connectionString);
     con.Open();
     Console.WriteLine(con.ServerVersion);
     return con;
 }

 public IDbCommand createCommand() {
     return new FbCommand();
 }
}


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com