On Sat, 17 Apr 2004 00:18:06 +0200 Alexander M. Turek wrote:
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.
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.)
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? :-)
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
Regards,
--
Alexander M. Turek rabus@users.sourceforge.net
_ __ __ _ _ __ __ | |__ _ __ | / |_ _ / \ __| |_ __ ___ (_)_ __ | '_ | '_ | '_ | |/| | | | | / _ \ / _` | '_ ` _ | | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|__, /_/ ___,_|_| |_| |_|_|_| |_| |_| |_| |___/ http://www.phpmyadmin.net
This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel