Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mysql spatial in SQL Developer

CrackerJackAug 9 2012 — edited Sep 11 2012
Hi,

Managed to connect to mysql database using the worksheet hints ( thanks SQL Developer Team!)

I managed to get teh GEOMETRY column of mysql in Oracle but when viewed in SQL Developer it gives binary text for GEMTERY column.

ANy idea why ..and not retrurning the normal latitude longitude?

E.g:

00000000010300000001000000E0010000FDA4DAA7E3393BC0AB2006BAF61D63402385B2F0F5393BC05DDC4603F81D6340A568E55E603A3BC03750E09DFC1D6340FC00A436713A3BC00D553195FE1D634036E84B6F7F3A3BC07CD3F4D9011E634095F0845E7F3A3BC0583CF54803

Asked in SQL Developer forum as well if they might have experience.

Cheers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2012
Added on Aug 9 2012
10 comments
598 views