in reply to SQLite and Storable: is "Text" okay?
If you're using SQLite 3, the TEXT type stores data UTF encoded, while the BLOB type stores it raw. BLOB is more geared toward binary data storage.
If you're really concerned about problems due to UTF encoding, use a BLOB. It looks like Storable deals with UTF8 fine, but I don't know how much it likes UTF16. Since Storable generates a string, I would probably store it as a text column.
If you're using SQLite 2, all the datatypes are really strings. You could declare the column as an INTEGER and it wouldn't care. I would still pick TEXT, because it describes the data the best.
Edit: I misread the Storable docs. See below for details.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: SQLite and Storable: is "Text" okay?
by ikegami (Patriarch) on Oct 06, 2010 at 15:53 UTC | |
by assemble (Friar) on Oct 06, 2010 at 17:11 UTC | |
by ikegami (Patriarch) on Oct 06, 2010 at 17:43 UTC |
In Section
Seekers of Perl Wisdom