On Thu, Mar 09, 2006 at 10:21:53AM -0500, Dan Ziemecki wrote:
If 'text' works for serialized objects, then that's probably what I need.
Unless you have binary data somewhere, I think.
Maybe in mySQL, too. I was just concerned that a text field would top out at 255 characters, and I wasn't sure how many I'd end up with.
In postgres TEXT has unlimited length (well, almost ;)). In mysql it can have 65K bytes.
I would suggest changing 'uid' name to something else, as it's reserved
name.
Hmm a small explanation: 'uid' is reserved in oracle and gives a lot of problems to people wanting to support oracle (http://drupal.org/node/39260)
Good point. Is 'type" ok? I've seen it elsewhere (e.g. Nodes) but I wasn't sure...
It's ok (I don't suppose we'll ever support to DB2 ;)). There's a nice web tool on http://www.petefreitag.com/tools/sql_reserved_words_checker/
Those are also good, if you really want comments.
Why wouldn't you? Is there a cost? Otherwise, anything that explains what's going on can only help in later troubleshooting, no?
No no, I don't know about any problems with comments, I just never used them ;) -- Piotrek irc: #debian.pl Mors Drosophilis melanogastribus!