Walter Neumann wrote:

>>> I have a database on Firebird 1.5 on a windows server with the
>>> characterset WIN1252. Now I have request some data with PHP with
>>> characterset UTF-8. What would be the best way to convert the data?
>>> 2. Is it right, if I connect to the database with UTF-8, that the
>>> database engine convert the data itselve?
>> Yes, that's right.
>>
>> If you need everything in UTF-8 on the client side, than it's also the
>> best way.
>
> Thank you for your suggestion. But it don't work. By the statement
> ibase_fetch_object I recieve the error "arithmetic exception, numeric
> overflow or string truncation". A typical error, if the charset don't match.

That would mean that Firebird cannot translate WIN1252->UTF8 which is,
well, impossible. I haven't tried with Firebird 1.5, but with 2.0 it
works fine.

If you use some admin. tool (ex. FlameRobin) and set UTF-8 as connection
charset, do you get the same error?

> charset in ibase_connect is UTF-8. What could be wrong?

It's hard to tell, as everything seems fine the way you wrote it. Is
there some chance you can test with Firebird 2?

--
Milan Babuskov
http://www.flamerobin.org