Hi devels
I thought about integrating OpenGIS datatypes in phpMyAdmin. They are available for mysql >= 4.1. What do you think about integrating them? Should we make them work for PMA 2.6.0 or not?
Marcel
Hi Marcel & list,
Marcel Tschopp wrote:
I thought about integrating OpenGIS datatypes in phpMyAdmin.
We'll have to, sooner or later. The sooner, the better.
They are available for mysql >= 4.1.
I know, but I haven't had a look at them yet.
What do you think about integrating them? Should we make them work for PMA 2.6.0 or not?
Could you? :-)
Regards,
On Sat, 17 Apr 2004 00:18:06 +0200 Alexander M. Turek wrote:
But I think it is better to integrate them after 2.6.0 because it's a hard work to integrate them (many new functions, only available on servers >= 4.1, 8 datatypes, special data input, special data reading, etc.)
Eventually basic support. But look at that simple example:
INSERT INTO `test` ( `id` , `geometry` ) VALUES ('', GeomFromText('LINESTRING( 1 1, 3 3, 7 7)'));
SELECT * FROM test; +----+---------------------------------------------------------------+ | id | geometry | +----+---------------------------------------------------------------+ | 1 | | +----+---------------------------------------------------------------+ 1 row in set (0.00 sec)
SELECT id, AsText(geometry) AS geometry FROM test; +----+-------------------------+ | id | geometry | +----+-------------------------+ | 1 | LINESTRING(1 1,3 3,7 7) | +----+-------------------------+ 1 row in set (0.00 sec)
Would be a big piece work to display GIS data in right format because the data is stored binary.
Best regards Marcel Tschopp
-
Alexander M. Turek -
Marc Delisle -
Marcel Tschopp