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: 136
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