[Firebird-net-provider] Charset

[paha]

Hi, i need help, i'm soooo stupid, i can't solve the problem: I have next function to execute SQL command public bool ExecSQL(string SQL) { bool result = true; try { if (m_fbConnection.State == System.Data.ConnectionState.Open) m_fbConnection.Close(); m_fbConnection.Open(); FbTransaction m_fbTransaction = m_fbConnection.BeginTransaction(FbTransactionOptions.Concurrency); FbCommand cmd = new FbCommand(SQL,m_fbConnection,m_fbTransaction); cmd.ExecuteNonQuery(); m_fbTransaction.Commit(); } catch (Exception ex) { acsMessage.Error(ex.Message, "Ausführen von SQL Anweisung"); result = false; } finally { m_fbConnection.Close(); } return result; } my connection string is : data source=192.168.100.5;user id=sysdba;password=masterkey;initial catalog=C:\0_Projekte\ACS\acs001.gdb;port number=3050;character set=WIN1252;pooling=True;connection lifetime=30;connection timeout=5;server type=Default Database columns have also win1252 character set (with ISO8859_1 i've tried also) And now the error : if i execute for instance "insert into test values('test','Ü')" - i insert some german character - is everything ok, but if i use "update test set field1='aa' where field2='Ü'" - i get "cannot transliterate from character set". What have i done wrong? Execution via ODBC or in IBExperts brings no errors I use latest FB2.0 .Net Provider with Firebird 1.5 and VS2005PRO P.S. putting "charset blablabla" instead of "charset win1252" - brings also no error, is there no check for correct charset name??? Please, need some help :-)

---

View this message in context: Charset
Sent from the firebird-net-provider forum at Nabble.com.