[CdnBloodlust]

stef70: Cool thanks for a heads up on that, I might use that information at some point.

xuyn2003: I believe the graphical application replaces all strange characters with question marks. Probably some regex. I wonder if it would be possible to patch the application so it doesn't filter out characters, but that may lead to messed up looking characters if the character encoding isn't utf-8. Maybe you could manually add the files to a database with encoding information.

What I'll probably be doing the next time I feel like messing with the device is manually editing the database files.

Here's some notes I've made on the databases.

# INSERT INTO "content" VALUES('file:///mnt/onboard/sd/strings-fickel.epub#(0)','902','application/epub+zip','file:///mnt/onboard/sd/strings-fickel.epub','Unknown',NULL,'Unknown','',NULL,NULL,NULL,'',NULL,'false',NULL,'true',NULL,0,0,NULL,0,736635860,0,'2011-10-01T13:57:04','adobe_user',NULL,0,0,0,NULL,-1,1,NULL,NULL,NULL);
# INSERT INTO "content" VALUES('file:///mnt/onboard/sd/strings-fickel.epub','901','application/epub+zip',NULL,NULL,'file____mnt_onboard_sd_strings-fickel_epub','Unknown','Unknown',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,1,0,3787336,0,'2011-10-01T13:57:04','adobe_user',NULL,NULL,NULL,0,0,-1,1,NULL,'en_CA','');
% sqlite3 -header -line /home/foo/KoboReader.sqlite 'select * from "content" where ContentID = "file:///mnt/onboard/sd/strings-test.epub";'
          ContentID = file:///mnt/onboard/sd/strings-test.epub
        ContentType = 901
           MimeType = application/epub+zip
             BookID = 
          BookTitle = 
            ImageId = file____mnt_onboard_sd_strings-fickel_epub
              Title = Unknown
        Attribution = Unknown
        Description = 
        DateCreated = 
      ShortCoverKey = 
     adobe_location = 
          Publisher = 
        IsEncrypted = false
       DateLastRead = 
   FirstTimeReading = true
ChapterIDBookmarked = 
ParagraphBookmarked = 0
 BookmarkWordOffset = 0
     NumShortcovers = 1
        VolumeIndex = 0
        ___NumPages = 3787336
         ReadStatus = 0
        ___SyncTime = 2011-10-01T13:57:04
          ___UserID = adobe_user
      PublicationId = 
      ___FileOffset = 
        ___FileSize = 
     ___PercentRead = 0
___ExpirationStatus = 0
    FavouritesIndex = -1
      Accessibility = 1
         ContentURL = 
           Language = en_CA
      BookshelfTags = 



% sqlite3 -header -line /home/foo/KoboReader.sqlite 'select * from "content" where ContentID = "file:///mnt/onboard/sd/strings-test.epub#(0)";'
          ContentID = file:///mnt/onboard/sd/strings-test.epub#(0)
        ContentType = 902
           MimeType = application/epub+zip
             BookID = file:///mnt/onboard/sd/strings-fickel.epub
          BookTitle = Unknown
            ImageId = 
              Title = Unknown
        Attribution = 
        Description = 
        DateCreated = 
      ShortCoverKey = 
     adobe_location = 
          Publisher = 
        IsEncrypted = false
       DateLastRead = 
   FirstTimeReading = true
ChapterIDBookmarked = 
ParagraphBookmarked = 0
 BookmarkWordOffset = 0
     NumShortcovers = 
        VolumeIndex = 0
        ___NumPages = 736635860
         ReadStatus = 0
        ___SyncTime = 2011-10-01T13:57:04
          ___UserID = adobe_user
      PublicationId = 
      ___FileOffset = 0
        ___FileSize = 0
     ___PercentRead = 0
___ExpirationStatus = 
    FavouritesIndex = -1
      Accessibility = 1
         ContentURL = 
           Language = 
      BookshelfTags = 
sqlite3 /tmp/KoboReader.sqlite < sql-commands.txt
ebook-convert /home/foo/unsorted/links.txt /home/foo/onboard/links.epub

Those are just random notes in no particular order.

Also note the last command ebook-convert which came with calibre as a command line program which you could use to convert chinese txt to epub possibly, then copy the epub over to the kobo with wifi, then modify the database so it sees the newly added epub.

Not sure what the numpages value is exactly, anyone have info in that? 3787336 does not look like a number of pages. Also I believe the epub was 2 or 3 pages long in this database.