Support for new data types in MySQL 4.1?

[Fabian Kurth]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]