[Firebird-net-provider] Transliterate character

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

Hello,

I have some problems with different character sets. I
have a table with a column of type VARCHAR(32764)
CHARACTER SET ISO8859_1 and want to use the Firebird
.Net Dataprovider (1.5.1318.34382) to insert rows.
Here an example from C++ .NET:

IDbCommand* pCMD = m_DBConnection->CreateCommand();
IDbTransaction* pTrans =
m_DBConnection->BeginTransaction(IsolationLevel::ReadCommitted);
pCMD->Transaction = pTrans;
pCMD->CommandText = "INSERT INTO TEST VALUES ('ä')" 
pCMD->ExecuteNonQuery();
pTrans->Commit();

This doesn’t work. ExecuteNonQuery yields this
message:

arithmetic exception, numeric overflow, or string
truncation
Cannot transliterate character between character sets

The CommandText property is a Unicode string
containing a character above ASCII 127 ('ä'). How can
I write this character to the table field of type
ISO8859_1?

Can anybody help me?

Thanks, OAS


__________________________________________________________________

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