Re: [Firebird-net-provider] Re: Re: Transliterate character

[<oas...@ya...>]

Hello Carlos,

I'm really sorry that I didn't realized the missing
";"! Of course you're right. The sample code works
fine and it isn't important which character set I use
when creating the database.

Thanks a lot for your help!
OAS

 --- Carlos Guzman Alvarez <car...@te...>
schrieb: > Hello:
> 
> This connection string is bad:
> 
> Connection = new
> FbConnection("Database=TestChar.gdb; 
> USER=SYSDBA;Password=masterkey Charset=ISO8859_1");
> 
> it sholud be:
> 
> Connection  = new
> FbConnection("Database=TestChar.gdb; 
> USER=SYSDBA;Password=masterkey;Charset=ISO8859_1");
> 
> 
> I have made other test that is working fine too,
> here is the code:
> 
> FbConnection connection = new
> FbConnection(connectionString);
> connection.Open();
> 
> FbTransaction transaction =
> connection.BeginTransaction();
> 
> FbCommand command = new FbCommand("insert into
> test_table_01(int_field, 
> char_field) values (10020, 'äëïöü')", connection,
> transaction);
> 
> command.ExecuteNonQuery();
> 			
> transaction.Commit();
> command.Dispose();
> transaction.Dispose();
> 
> connection.Close();
> 
> 
> 
> 
> -- 
> Best regards
> 
> Carlos Guzmán Álvarez
> Vigo-Spain
>  

__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de