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

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

Hello:

> ---
> command = new FbCommand("insert into \"test\" (\"unicode_fss\") VALUES
> ('<russian text>')", connection, transaction); // in VALUE i use russian
> text
> command.ExecuteNonQuery();
>
> command = new FbCommand("insert into \"test\" (\"win1251\") VALUES
> ('<russian text>')", connection, transaction); // in VALUE i use russian
> text
>
> command.ExecuteNonQuery();


Can you try using parametrized querys, please ?? Anything like this :

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


This needs to handle correctly the character set of each field.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain