How to store array in one column in Sqlite3?

Posted by SPK on Stack Overflow See other posts from Stack Overflow or by SPK
Published on 2010-06-09T11:12:35Z Indexed on 2010/06/09 11:22 UTC
Read the original article Hit count: 132

Filed under:
|

Hi,

Is there any way to store an array of integers in one column of table? I want o/p like this:

ident | value | count ----------------+------------------------------------------------------------------------------------------------------------------------+------- 563 | [0:10]={"(0,0)","(1,100)","(2,200)","(3,300)","(4,400)","(5,500)"} | 6

This I have already acheieved through postgres but i want same o/p from sqlite also. Here column value store an array. I tried it through BLOB but it is not working. Somebody told me about serialized way but i am not sure how to do that.

Please help.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about c++

Related posts about sqlite3