Re: [Firebird-net-provider] I have problem with russian language

[<car...@te...>]

Hello:

> Exception:
>
> Cannot transliterate character between character sets


It's working fine for me, here is my test database:

SET SQL DIALECT 3;

SET NAMES UNICODE_FSS;

CREATE DATABASE 'LOCALHOST:c:\test.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET UNICODE_FSS;

CREATE TABLE "test" (
    "unicode_fss"  VARCHAR(128) CHARACTER SET UNICODE_FSS,
    "win1251"      VARCHAR(128) CHARACTER SET WIN1251
);

And here is my C# code:

string connectionString =
    @"Database=D:\TEST.GDB;" +
    "User=SYSDBA;" +
    "Password=masterkey;" +
    "Server=localhost;" +
    "Port=3050;" +
    "Dialect=3;" +
    "Charset=UNICODE_FSS;" +
    "pooling=false;" +
    "Role=;";

FbConnection connection = new FbConnection(connectionString);
connection.Open();

FbTransaction transaction = connection.BeginTransaction();

string sql = "insert into \"test\" (\"unicode_fss\", \"win1251\") values 
(@unicodeValue, @win1251)";
FbCommand unicode_insert = new FbCommand(sql, connection, transaction);
unicode_insert.Parameters.Add("@unicodeValue", FbDbType.VarChar).Value = 
"áéíóú";
unicode_insert.Parameters.Add("@win1251", FbDbType.VarChar).Value = "áéíóú";
unicode_insert.ExecuteNonQuery();
           
transaction.Commit();

connection.Close();



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain