[firebird-support] cannot transliterate Firebird 1.5

 

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.

 

__._,_.___

---

Posted by: blumy2005@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___