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 26 27 28
| CREATE DATABASE '..\Data\Base.fdb' page_size 4096 DEFAULT CHARACTER SET ISO8859_1;
CREATE TABLE GRADE (
GRADE_ID INTEGER NOT NULL,
INTITULE_GRADE VARCHAR(50) COLLATE ISO8859_1
);
COMMIT;
INSERT INTO GRADE (GRADE_ID,INTITULE_GRADE) VALUES (1,'Agent administratif');
INSERT INTO GRADE (GRADE_ID,INTITULE_GRADE) VALUES (2,'Ingénieur dEtat en Informatique');
Statement failed, SQLSTATE = 22018
arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets
After line 10 in file Base.sql
COMMIT;
select* from GRADE;
GRADE_ID INTITULE_GRADE
============ ==================================================
1 Agent administratif
EXIT
Appuyez sur une touche pour continuer... |