How big is the text I want to store?

[SeanHarding]

Is there a way of detecting how big my unserialize() array is before I store it?

 

TEXT will hold 65K and LONGTEXT will hold 4GB.

 

If the string is too long I would like to reply with a message.

[requinix]

Any reason you're serializing() data?

[The Little Guy]

This should work: mb_strlen

[SeanHarding]

Sorry for the long reply.

 

I will be serializing my multidimensional array as the arrays are user generated.

I would prefer to create and store arrays rather than create numerous tables in MySQL.

 

With mb_strlen() does 1 character = 1byte?

I'm assuming I'd use mb_strlen($string, '8 bit');

[fenway]

This sounds like a follow-up to you other question.

[requinix]

With mb_strlen() does 1 character = 1byte?

I'm assuming I'd use mb_strlen($string, '8 bit');

1. The "mb" means "multibyte". Because not all characters are one byte long. mb_strlen() counts characters while strlen() counts bytes.

2. No. Use the same character encoding that your *TEXT column uses.

[fenway]

I would prefer to create and store arrays rather than create numerous tables in MySQL.

That sounds like a plan doomed to fail.

[SeanHarding]

Its certainly an interesting project.

 

I'm doing allot of math during the project and instead of creating multiple requests I'll be manipulating the array and storing it later.