Re: Cannot get geometry object from data you send to the GEOMETRY field

[Albert Rovira]

Hi,

You must ensure you build a valid WKT geometry. If you have a simple polygon you must format like:

POLYGON((x0 y0, x1 y1, x2 y2, ... , xn yn, x0 y0))

so something like

insert into tbl_bdy_geom (code,bdy,geoloc)
select code,bdy,polyFromText(concat( 'POLYGON((', REPLACE(`bdy`, '|', ',') , '))' ) from `tbl_bdy;

does the job if on your coordinate sequence has the same point on the first and the last position.