On 20 Jan 2010, at 3:42am, RevBayes wrote: > I was trying to use the .import tool in sqlite. I was wondering if there was > a way to specify any arbitrary ascii character via the .separator command. > > e.g. if i want to use 0x05 (some non-printable ascii char) as the separator, > how do i specify it in the .separator command.
See '.separator' in http://www.sqlite.org/sqlite.html Either figure out how to type that character or tell sqlite to take its commands from a file written to disk. Alternatively, use your OSes tools to make a global change in your import file from 0x05 to some saner type-able character. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users