Subject Problem with select on IB_QUERY
Author Marcelomac
Dear friends,

I have the select:

select count(*)as PAT6 from PACIENTS
where PATOLOGIA = 'CongĂȘnita'

that shows the message:

ISC ERROR CODE: 335544321
ISC ERRORMESSAGE:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets

for search words with accents or two words (space between)

I use Charset win1252 / collate PXW_intl850

Firebird 2.0 / Delphi7 and IBO 4.8