Thanks Adam, Could you kindly post an example file somewhere (the kind which you import) for us to test with? (The list does not allow attachments).
Also, could you try a later version of SQLite so that we could see if this problem still exists on your platform. Updated versions obtainable from: http://www.sqlite.org/downloads/ Thanks. Ryan On 2015-02-26 12:10 PM, Adam Podstawczy?ski wrote: > Hi all, > > Thanks for trying to help. Answering all suggestions and questions: > > 1. I don?t think this is a presentation issue: I exported the data which I > had imported earlier, and the issue is there in the exported files. > > 2. Version information: > > Last login: Thu Feb 26 09:06:41 on ttys004 > Hg:locs adampodstawczynski$ sqlite3 --version > -- Loading resources from /Users/adampodstawczynski/.sqliterc > > 3.8.7.1 2014-10-29 13:59:56 3b7b72c4685aa5cf5e675c2c47ebec10d9704221 > Hg:locs adampodstawczynski$ cat ~/.sqliterc > .headers on > .mode column > Hg:locs adampodstawczynski$ uname -a > Darwin Hg 14.1.0 Darwin Kernel Version 14.1.0: Mon Dec 22 23:10:38 PST 2014; > root:xnu-2782.10.72~2/RELEASE_X86_64 x86_64 > Hg:locs adampodstawczynski$ > > This is on Mac OS 10.10.2 (Yosemite). > > 3. I?m not doing any length() operation anywhere in the process, so there is > no risk of truncation because of that. I just import the data and the char > corruption issue is immediately there. > > Thanks,
