Subject cannot transliterate Firebird 1.5
Author

in my Builder c++ 6 application  i have  a SQL query for a table, in Firebird 1.5.6 fdb database


" where STRADA " + = QuotedStr(edText->Text). Field STRADA in table is define WIN1251


in edText, the are Romanian characters, like ş and ţ.


if the text not include romanian characters, the query is OK.


if the text include romanian characters, 'Românească'  the query error is

"Sql Error: arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets.