maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

well some conversion is done....

SQL:
drop table if exists a;
create table if not exists a(i bit(64)) ENGINE=MYISAM;
LOAD DATA LOCAL INFILE "c:\\spadim\\t.txt"
IGNORE INTO TABLE `a` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' (i);
select * from a;

RESULT:
i
00001101
00001101
00001101
00001101
00001101
00001101
00001101
00001101


file t.txt attached
[image: Imagem inline 1]

0
1
\0
\1
b'0'
b'1'