Create standard type set about data HOT 7 CLOSED

string = text, varchar,varchar2, char etc.
date = date, datetime
int = any numeric value, int, smallint, longint, float, numeric, ?timestamp?
boolean = bool, tinyint(1), int, enum etc.

from data.

This list can be useful too: http://php.net/manual/en/mongo.types.php

from data.

so there can also be these types:

• array - array, list (mostly for NoSQL, but SQL can store them with json_encode or serialize for example)
• binary - BinaryData for NoSQL, BLOB for SQL

from data.

After thinking - the type conversion will be handled by Persistence SQL just when the data comes off the iterator before it's passed into $model->data

• When query is being built also build a "transformation" consisting of [field=>fx, ..] array.
• When results are fetched, pass them through transformator
• Allow fields to define custom transformators

from data.

if we use "int" we should use "bool" btw.

from data.

definition of having a type - if field has a type then persistence will normalize it.

I suppose if we add 'array' into allowed typess, then MySQL will have to serialize it.

from data.

Fully fixed in #130

from data.