Hi, I was wondering what the best way to store dynamic arrays in SQL was. The 2 options I can think off off the top of my head are:

1) create new tables for the items you want stored in the dynamic array and reference by the first table's key values (I.E. I have table CHARACTERS and I want an inventory list of items of dynamic length, so I make table ITEMS and attach each item to the character's name).

2) use a varchar string, with hashed out values of the items. But this would require, in theory, VERY long strings, which might become a burden?

I won't have to access this information too incredibly often, so speed isn't a huge, huge deal. If anything the write time is more important than the read time.