BorlandTalk.com

Mike Walker · Guest

Hi!

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?