[Phpmyadmin-devel] OpenGIS Datatypes (mysql >= 4.1)

[Marcel Tschopp]

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 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel