MySQL Forums
Forum List  »  PostgreSQL

Migrating geometry data
Posted by: n p
Date: November 07, 2007 04:29PM

Hi,

I have a PostGis database which has some data as type Geometry.
I'm sure there is a more elegant way but I just created the tables again in MySQL and then did a search and replace in the SQL dump from PostGIS so that I could insert the values into MySQL.
Unfortunately, it doesn't seem to like the geometry data which is expressed as '010100000089416065572920410AD7A370A9A6FA40'.
The exact error message is: "Data truncation: Cannot get geometry object from data you send to the GEOMETRY field"
I'm not sure if MySQL stores geometry data in this way... Does anyone know a way of converting the geometry data so that it can be stored in MySQL?


Thanks,

NP



Edited 2 time(s). Last edit at 11/07/2007 04:58PM by n p.

Options: ReplyQuote


Subject
Views
Written By
Posted
Migrating geometry data
12558
n p
November 07, 2007 04:29PM
7153
November 08, 2007 02:42AM
7275
n p
November 08, 2007 07:33AM
6802
November 09, 2007 01:18AM
10417
January 13, 2008 10:20AM
7096
February 03, 2008 06:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.