How store a unsigned short into a database

[franco.amato]

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

[wysota]

You cannot find a correct type for what?

[franco.amato]

You cannot find a correct type for what?

Wysota hi,
I can not find a correct type in the database that can store a ushort.
Regards

[wysota]

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.

[ChrisW67]

For SQLite it doesn't matter as it will store it as text anyway.
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).
http://sqlite.org/datatype3.html