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(a)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=cli…
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel