Text Field Default Value

View: New views
2 Messages — Rating Filter:   Alert me  

Text Field Default Value

by mother_taraza :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi:

I'm new to MetaL and wish to ask you guys something that has been
puzzling me over the last two days.

I'm using the lastest stable MySQL 5 release (comunity edition) +
Apache (with PHP -also the latest-). I've read the documentation quite
deeply but when trying to create the MetaNews sample database...
install.php warns about not being able to give a text column a default
value. Such thing it explicitly banned in the MySQL docs... so I'm
afraid MySQL 5 it is not compatible with MetaL...
Could this be true?

I'm quite interested in using MetaStorage for my next personal
project(s) so I'll be glad to hear from you ASAP.

Regards.


Re: Text Field Default Value

by mlemos :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

on 03/07/2007 06:00 AM mother_taraza said the following:

> Hi:
>
> I'm new to MetaL and wish to ask you guys something that has been
> puzzling me over the last two days.
>
> I'm using the lastest stable MySQL 5 release (comunity edition) +
> Apache (with PHP -also the latest-). I've read the documentation quite
> deeply but when trying to create the MetaNews sample database...
> install.php warns about not being able to give a text column a default
> value. Such thing it explicitly banned in the MySQL docs... so I'm
> afraid MySQL 5 it is not compatible with MetaL...
> Could this be true?
>
> I'm quite interested in using MetaStorage for my next personal
> project(s) so I'll be glad to hear from you ASAP.

If you do not specify a text variable length, it will attempt to create
a table with a TEXT field. TEXT fields are basically character LOBs, so
they may not have default values.

If you specify a variable length, it will create a VARCHAR field that
can have a default value.

--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/
LightInTheBox - Buy quality products at wholesale price