2. PHPRunner General questions
  3. Database Field Types
This topic is locked

Database Field Types

 		12/16/2009 18:19:08
PHPRunner General questions
R
 RockyMtnHi author

I am thinking of using an upsizing tool (http://www.bullzip.com/products/a2m/doc/info.php#Prerequisites) to take an Access database into a MySQL database. It looks like not all of the MySQL field types are used in PHP Runner, so I'm wondering what will happen if a field type not used within PHP Runner is in the MySQL table for the application?
Any insight into this?
Thanks
Pfeiffer 12/16/2009

Hello,

MSAcess ist not full compatible with MYSQL.

So you have to plan exactly which field you will use in MYSQL.
I converted too an access database to mysql and could always use field types which PHPR could manage

and I'm missing nothing...
Perhaps you have a problem with a special field type ????
Best regards

Uwe Pfeiffer
R
 		RockyMtnHi author 12/16/2009



Hello,

MSAcess ist not full compatible with MYSQL.

So you have to plan exactly which field you will use in MYSQL.
I converted too an access database to mysql and could always use field types which PHPR could manage

and I'm missing nothing...
Perhaps you have a problem with a special field type ????
Best regards

Uwe Pfeiffer


Not a problem with a special field type as much as knowing that some of the field types translated to MySQL will possibly not be in the PHPR list of field types so I am wondering what PHPR would do with the MySQL database field types not in the PHPR list.
J
 		Jane 12/17/2009

Hi,
please be more specific: what MySQL field types do you use?