we have a table with a field of tpye binary(16)
we unload this database, then try to rebuild from the script.
the text files contains the correct binary formats, like 0x3d42...
however, INPUT INTO loads the data incorrectly. it reads it as a
character data
and translates to binary (that is, the result is 0x307833...)

details:

adaptive server anywhere 8.0.2

field definition: password binary(16) not null

a record in the output file is like :
9,,'GM','Zon','Vasz','Vasz Zon',,'ACTV','2003-09-18
00:00:00.000',,'OK',,1,1,0x45c48cce2e2d7fbdea1afc5 1c7c6ad26,9,1,

input command is as generated by the unload utility:
INPUT INTO "DBA"."users" FROM 'C:\\Temp\\unload\\440.dat' FORMAT ASCII
BY ORDER

it runs without errors, but the data in the table is:
0x30783435633438636365326532643766

what can we do?

thanks in advance
Krisztian Pinter
pinterkr (AT) freemail (DOT) hu