[Typo3-dev] DBAL

[Karsten Dambekalns]

Hi,

I wanted to do the same. But read on...

On 2004-08-02, dan frost <dan at danfrost.co.uk> wrote:
> Michael Stucki wrote:
>> Martin T. Kutschker wrote:
>>>Is there any reason besides the point that the data is "hidden" for
>>>those who use phpMyAdmin? If it's a problem convert all those config
>>>fields that are blobs into text fields.

No. This has nothing to do with it. Besides, phpMyAdmin can be
configured to show BLOB field contents.

>> I was going to ask exactly the same thing! What are all those blob fields
>> for?

They contain serialized PHP arrays as far as I know (I have not looked
at every field's contents).

Serialized PHP arrays are suited to be handled as strings inside PHP,
but they are still binary - they may contain binary 0 and other nifty
things. It all depends what has been serialized.

This would not make a big difference with MySQL as it is today, but
other databases may try to 'help' you with the fields contents. If
they see a character field and are using a certain charset this could
be very bad for your data... :)

> I agree - can we go *text where possible please?

Of course. Someone would have to find out where exactly it *is*
possible. I won't do this (in the near future at least) and BLOB
fields are working well by now.

Karsten