Fabio Gomes wrote:

>My firebird database is using 8859-1 charset, but when i do a WHERE with
>something like:
>
>WHERE name LIKE '%cássia%'
>
>It gives me this error:
>
>arithmetic exception, numeric overflow, or string truncation Cannot
>transliterate character between character sets
>
>Whats the problem? and how can i fix it?
>
>I m using firebird 1.5, with dialect 3 and running the query using php.
>
>And the field that gives me this error is VARCHAR(50) ISO8859_1
>
>Thanx in advance for any help.
>
>
>

Fabio,

Make sure your connection character set is ISO8859_1 too

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br