Any way for Doctrine HYDRATE_ARRAY to preserve data type?

Question

I'm retrieving some data using Doctrine 1.2 ORM from a database on a symfony 1.4 project. Currently using a simple query and returning with:

Doctrine::HYDRATE_ARRAY

Is there any way to preserve data types using this method? All data types are cast to a string instead of maintaining a respective int, float, etc based on the database column type...

I would assume that doctrine would be developed enough at this point to maintain data type integrity when appropriate.

Answer 1

From Doctrine docs:

You should always use array hydration when you only need to data for access-only purposes, whereas you should use the record hydration when you need to change the fetched data.

So the next text I will put is NOT a good idea, but could answer your question.

Doctrine gives you the serialize or unserialize (YOU SHOULD USE THIS, SEE EXAMPLE) to get the objects. for example, you fetch an array of users, for each one you could run :

$user = unserialize($string);

where string is the serialized object or equally one of the elements of the fecthArray() result