Yes, client and server has to be the sames ...
Your answer helped me a lot, and your link much much more !

for information
on windows charset to be set for isql/fsql is DOS850 or DOS858 !

It can be set via SET NAMES before CONNECT
or directly in the isql -ch parameter in fsql or isql (FB 20)

Thanx for the help
Regards
PAscal

--- In firebird-support@yahoogroups.com, Stefan Heymann <lists@...> wrote:
>
> Pascal,
>
> you must use the same character set for the database (server side) and
> for the client. ISO8859_1 is OK for French.
>
> See more here: http://www.destructor.de/firebird/charsets.htm
>
> Best Regards
>
> Stefan
>
>
>
> > Hello,
> > On windows XP, I'm not able to see the same french characters résults
> > depending on witch tool is creating/selecting data.
>
> > Here is the case:
>
> > after creating a database with ISO8859_1 charset
> > with a table
> > create table TT (l varchar(10));
>
> > from isql:
> > insert into tt (l) values ('aéèàùçzISQ');
> > from IBExpert:
> > insert into tt (l) values ('aéèàùçzIBE');
>
> > select l from tt;
> > from ISQL
> > L
> > ==========
> > aÚÞÓ¨þzIBE
> > aéèàùçzISQ
>
> > from IBexpert
> > aéèàùçzIBE
> > a?????zISQ
>
> > I have tried to use -ch ISO8859_1/SET NAMES ISO8859_1 option within
> > isql without any success
>
> > How could I correct this ?
>
>
> --
> Stefan Heymann
> www.destructor.de/firebird
>