|
|
Posted by Jim Michaels on 02/14/06 07:42
even though the serialized data should be stored as a VARBINARY or a BLOB,
you could possibly still do a search using LIKE using your existing data
type.
the text data is embedded inside the serialized string as plaintext and
should be searchable with LIKE %somestring% although a bit slower than other
searches.
"thehuby" <thehuby@gmail.com> wrote in message
news:1139847450.234541.310840@g43g2000cwa.googlegroups.com...
>I think that using implode/explode would be the best way as this means
> you can use native SQL to search the database (WHERE array_col LIKE
> '%2%' or whatever), rather than having to comparison check each
> serialised object by pulling the data out, transforming, doing an array
> lookup etc.
>
> Quite a clever way of doing it actually!
>
> The other way of doing it would be to use SQL 'properly' and use a
> table for whatever the array numbers of reference (I am assuming a PK
> on another table or an index in an array), then using SQL to search
> through the whole thing.
>
> Either way, avoiding serialization will allow you to port the language
> at a later date to another language (ASP, JSP etc.). Not something you
> might be thinking of right now but it could be useful.
>
Navigation:
[Reply to this message]
|