Evan Martin (evan) wrote in evan_tech,
Evan Martin

sqlite3 weak types gotcha

sqlite> create table test (subject string);
sqlite> insert into test values ('2.0');
sqlite> select * from test;
What if, y'know, I had a program that wanted to actually store the string "2.0" in a database and be able to fetch it back later? Ok, that's not hypothetical.

The trick is that while sqlite generally ignores the column types you give it, the proper type for string columns is "text" and not "string" or "char".

  • your vcs sucks

    I've been hacking on some Haskell stuff lately that's all managed in darcs and it's reminded me of an observation I made over two years ago now (see…

  • perl people, explain your language to me

    Every time I use perl I feel mildly positive about it right up until I encounter CPAN. I've never managed to make CPAN work, despite the multitude of…

  • dns attack of doom

    If I've learned anything from the new Kaminsky DNS attack, it's that if you want to keep something a secret while disclosing to a trusted subset of…

  • Post a new comment


    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.