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.

Reply via email to