Subject | Problems with chars like á é ó, etc charset problem? |
---|---|
Author | Fabio Gomes |
Post date | 2005-11-29T12:32:53Z |
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.
[Non-text portions of this message have been removed]
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.
[Non-text portions of this message have been removed]