Support for new data types in MySQL 4.1?

[Fabian Kurth <fa...@bluewin.ch>]

MySQL 4.1 includes "spatial extentions" which make it possible to assign 
columns the GEOMETRY data type, e.g.

CREATE TABLE Foo (
  id      INT(10)  NOT NULL AUTO_INCREMENT,
  geo   GEOMETRY NOT NULL
)

and then to perform operations like

INSERT INTO Foo VALUES (GeomFromText('POINT(646747.00 251770.00)'));

Running JDBCToXMLSchema against an existing MySQL 4.1 database (that makes 
use of the GEOMETRY data type) yields an incorrect schema XML file (empty 
type attributes in the <column> tags).

Is it true that Torque 3.1 does not yet support the MySQL GEOMETRY data 
type? If yes, is there any workaround or way to "simulate" this data type in 
a schema file?

(See http://dev.mysql.com/doc/mysql/en/Spatial_extensions_in_MySQL.html )

Thanks, Fabian 



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org