1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| CREATE DATABASE '..\Data\Base.fdb' page_size 4096 DEFAULT CHARACTER SET NONE;
SET NAMES NONE;
create table test (
id int not null primary key,
lib char(50) not null,
carac char(50) not null);
insert into test (id,lib,carac) values (10, 'Windows-1252 - 128 - euro ', x'80');
insert into test (id,lib,carac) values (11, 'Windows-1252 - 156 - oe ', x'9C');
insert into test (id,lib,carac) values (12, 'Windows-1252 - 231 - c cedille', x'E7');
insert into test (id,lib,carac) values (20, 'ISO_8859_15 - 164 - euro ', x'A4');
insert into test (id,lib,carac) values (21, 'ISO_8859_15 - 189 - oe ', x'BD');
insert into test (id,lib,carac) values (22, 'ISO_8859_15 - 231 - c cedille', x'E7');
insert into test (id,lib,carac) values (30, 'UTF8 - 164 - euro ', x'E282AC');
insert into test (id,lib,carac) values (31, 'UTF8 - 189 - oe ', x'C593');
insert into test (id,lib,carac) values (32, 'UTF8 - 231 - c cedille', x'C3A7');
select * from test;
exit; |
Partager