View Single Post
Old 02-03-2015, 12:43 PM   #63
frostschutz
Linux User
frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.frostschutz ought to be getting tired of karma fortunes by now.
 
frostschutz's Avatar
 
Posts: 2,282
Karma: 6123806
Join Date: Sep 2010
Location: Heidelberg, Germany
Device: none
Quote:
Originally Posted by Ken Maltby View Post
What surprises me about frostschutz's post is that he just uses " " (a quoted space) for all the fields (both alphanumeric and binary [true/false]).
Empty string, actually.

If you .dump the Kobo database you'll see they often use the string 'false' or 'true' for those so-called binary fields. It should be 0 (for false) or 1 (for true) instead. Or at least, that's what the SQLite documentation recommends for boolean types which it doesn't have. Since Kobo uses strings, that's probably the correct thing to do for the Kobo.

It works, so whatever...

Last edited by frostschutz; 02-03-2015 at 12:48 PM.
frostschutz is offline   Reply With Quote