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.
