Subject | Problem with select on IB_QUERY |
---|---|
Author | Marcelomac |
Post date | 2010-07-21T22:28:57Z |
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
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