Hi to all,
I would store a unsigned short type ( 98 elements of ushort ) into a database ( ms sql express 2005 and sqlite ). But I can not find the correct type.
I would have some help.
Best Regards,
Franco
Hi to all,
I would store a unsigned short type ( 98 elements of ushort ) into a database ( ms sql express 2005 and sqlite ). But I can not find the correct type.
I would have some help.
Best Regards,
Franco
Franco Amato
For SQLite it doesn't matter as it will store it as text anyway. For other databases it will be something like SMALLINT or INTEGER(maximum_number_of_digits). If I understand correctly that you need an array of those then I think you need to rethink your design -- databases don't like arrays. You can store it as text separated by commas -- it will be as inefficient as any other kind of representation.
This is true of Sqlite2 but not Sqlite3, which uses a variable length binary representation of integer data in columns with numeric affinity (if possible).For SQLite it doesn't matter as it will store it as text anyway.
http://sqlite.org/datatype3.html
Bookmarks