On 2 Jul 2015, at 12:47pm, William Drago <wdrago at suffolk.lib.ny.us> wrote:
> Below is a .dump of the database I'm working with. I can use GetBytes() > successfully on all the BLOB columns except myTextArray. On that column I get > a System.InvalidCastException error. Can anyone tell me why? Thanks. SQLite has no inherent understanding of arrays. Although your code looks like it should just be storing and recalling the string "blue" "red" "orange" "yellow" with its quotes and space I suspect that some part of the Reader.GetBytes() routine is assuming it will get an array, whereas it's really just getting a chunk of octets. You may have to read the column into text, then use your language to split the text up into array elements. Simon.
