Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Zeos Acces + Firebird

7 views
Skip to first unread message

Mike Walker

unread,
Sep 7, 2005, 5:25:36 AM9/7/05
to
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?

0 new messages