Subject | FB 2.5.1 - cannot read external table file through text editor |
---|---|
Author | Roberto Carlos |
Post date | 2012-10-12T04:34:50Z |
I am using FB 2.5.1 on Windows 7 64 bits.
It works perfectly on FlameRobin 0.9.3.2219 Unicode (x64):
-----------------------
Create Database test.fdb Default Character Set utf8;
Create Table test15 External 'c:\mytable15.txt'
(
code1 Integer,
code2 Integer,
name char(20),
born date default current_date,
crlf char(2)
);
Commit;
Insert Into test15(code1, code2, name, born, crlf) Values(1, 2, 'abc', '01.01.2001', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(3, 5, 'def', '02.02.2002', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(5, 6, 'ghi', '03.03.2003', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(7, 8, 'jkl', '04.04.2004', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(9, 0, 'mno', '05.05.2005', ascii_char(13)||ascii_char(10));
Commit;
Select * From test15;
-----------------------
But when I open c:\mytable15.txt on Notepad++ 6.1.8 (UNICODE), I only can understand column NAME.
The other columns are not human readble.
Why I cannot read number and date fields on the text file, but Firebird show them perfectly on select statement?
Thanks for any help or hint.
It works perfectly on FlameRobin 0.9.3.2219 Unicode (x64):
-----------------------
Create Database test.fdb Default Character Set utf8;
Create Table test15 External 'c:\mytable15.txt'
(
code1 Integer,
code2 Integer,
name char(20),
born date default current_date,
crlf char(2)
);
Commit;
Insert Into test15(code1, code2, name, born, crlf) Values(1, 2, 'abc', '01.01.2001', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(3, 5, 'def', '02.02.2002', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(5, 6, 'ghi', '03.03.2003', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(7, 8, 'jkl', '04.04.2004', ascii_char(13)||ascii_char(10));
Insert Into test15(code1, code2, name, born, crlf) Values(9, 0, 'mno', '05.05.2005', ascii_char(13)||ascii_char(10));
Commit;
Select * From test15;
-----------------------
But when I open c:\mytable15.txt on Notepad++ 6.1.8 (UNICODE), I only can understand column NAME.
The other columns are not human readble.
Why I cannot read number and date fields on the text file, but Firebird show them perfectly on select statement?
Thanks for any help or hint.