I have problem with Zeos Access components for Delphi 6 and Firebird 1.5
database.
Table structure:
field "lastname" is varchar (30): Charset=win1250, Collate = pxw_slov
When I made zquery:
select * from mytable
where lastname = 'Maric'
order by lastname
all was OK, but when I tried this:
select * from mytable
where lastname = 'Mariæ'
order by lastname
I got next error message:
"Sql Error: arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between caracter sets. Error Code: -802.
Aritmetic overflow or division by zero acurred."
Any ideas?