[Zope-DB] data type problems ZMySQLDA

[Michele Marcionelli]

Hello Joey!

The correct syntax is:

CREATE TABLE ezine_news (
    author varchar(x),
    name varchar(x),
    content text,
    date timestamp
);

where "x" is the maximal length of the value, in this case "author" and
"name", usually x=255. I think that x can be an integer from 1 to 255.

Cheers,
Michele

----- Original Message -----
From: "Josiah Peters" <halo_maniac@hotmail.com>
To: <zope-db@zope.org>
Sent: Saturday, March 29, 2003 5:13 PM
Subject: [Zope-DB] data type problems ZMySQLDA


> I have been searching around and have not been able to find any reference
> information on ZmysqlDA. For some reason when i enter the query:
>
> CREATE TABLE ezine_news
> (
> author varchar,
> name varchar,
> content text,
> date timestamp,
> )
>
> it will not accept it as a legal query making me unable to finish my
> database stuff. Since I only have experience with MySQL and those commands
> do not seem to be working.
>
> thanks in advance.
>
> Joey Peters
>
> _________________________________________________________________
> Add photos to your messages with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>