thanks guys. I went to

asciitable.com and lookup the
hexadecimal equivalents on chr(1) and
chr(2). this file works:


load data
infile '/text.txt' "str X'02'"
truncate
into table test_table
fields terminated by X'01'
trailing nullcols
(composer,
p_id,
t_id)