Storing lists on SQL
- To: mathgroup at smc.vnet.net
- Subject: [mg106242] Storing lists on SQL
- From: Chris Degnen <degnen at cwgsy.net>
- Date: Wed, 6 Jan 2010 05:58:15 -0500 (EST)
Hi. I'm trying to store lists on an SQL database. The lists can contain strings, rules, lists and integers etc. I plan to store them in a variable character field as a single string, but the first problem is the quotes on the inner strings have to be elided, e.g./" At the moment I'm trying a recursive routine with ToCharacterCode to encode the inner strings first. I'll have to do something else for the rules. I'm also going to try serializing the lists with Export and then storing them encoded. (That might be easiest.) If anyone has suggestions on how I might store these lists please let me know.