Re: [Firebird-test] works on win2k(ib6) but not on linux(f1)

[Pavel C. <pc...@us...>]

Hi,

On 27 Sep 2002 at 13:53, wayne wrote:

> I update a record via dbExpress with actual data I
> send to the table is "a"
> 
> It works for ib6 on win2k but if i try to do it on
> f1 on a linux box it fails with a conversion error.
> 
> When I send numerical values all is fine.
> 
> My table does not specify any character sets or is set to none, I dont know
> what the impact is but I presume none.
> 
> Please advie what could be wrong or more data is required.

First, next time you'll have a better luck with support questions in 
appropriate forum (IB-Support mailing list, take a look at list of 
newsgroups and mailing lists at www.firebirdsql.org). This list is for 
Firebird QA efforts only.

Now to your question. You'll get conversion errors when character set of 
database and on client doesn't match. They will match if they are both 
NONE, or there is a conversion path from one character set to another. 
Conversion from/to NONE to any character set is not possible, so you'll 
always get the error (the most common case when this error appear).

So, if you have a character set defined for database, you have to set it 
also for client (where and how to set it depends on client tool / library 
you use). If you have the character set NONE on database, do not set it 
for client too (data would be stored as they're sent and returned as they 
are read).

Best regards
Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information