Subject | French special characters |
---|---|
Author | legrand_legrand_63 |
Post date | 2006-08-30T11:30:08Z |
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 ?
Regards
PAscal
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 ?
Regards
PAscal