Enrique, Your English is great so don't apologise!
Looking on the web site at http://www.mysql.com/doc/en/Spatial_extensions_in_MySQL.html , it appears that this feature was introduced in server version 4.1, so I'm afraid you'll have to upgrade your server. Best regards, Andy > -----Original Message----- > From: Enrique Andreu [mailto:[EMAIL PROTECTED] > Sent: 05 August 2003 08:08 > To: [EMAIL PROTECTED] > Subject: Problems with spatial extensions > > > Hi, I would like to have a column of a table of the > type GeometryCollection, but when I try to type a > simple example like the ones in the manual, I get > this: > > mysql> CREATE TABLE geom (g GEOMETRY); > ERROR 1064: You have an error in your SQL syntax. > Check the manual that corresponds to your MySQL server > version for the right syntax to use near 'GEOMETRY)' > at line 1 > > I'm running server mysqld-nt version 4.0.13 on a > windows NT, the mysql client is the same version. > > Have I to install some plug-in or change some option > in the configuration file? > I need help. > > Thanks and excuse me by the english (I'm spanish). > Enrique > > ___________________________________________________ > Yahoo! Messenger - Nueva versión GRATIS > Super Webcam, voz, caritas animadas, y más... > http://messenger.yahoo.es > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]