Subject | cannot transliterate Firebird 1.5 |
---|---|
Author | |
Post date | 2016-01-27T13:15:30Z |
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.