[adminer-tracker] [ adminer-Bugs and Features-3582578 ] can't export MySQL POINT type

[SourceForge.net <no...@so...>]

Bugs and Features item #3582578, was opened at 2012-11-01 15:35
Message generated for change (Comment added) made by himdel
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3582578&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: himdel (himdel)
Assigned to: Jakub Vrána (jakubvrana)
Summary: can't export MySQL POINT type

Initial Comment:
While browsing table data, the POINT fields are shown just fine (" POINT(49.1125051 16.3618832) ") but when I try to Dump the same table, the result is something like

(1,     'test',    ^@^@^@^@^A^A^@^@^@^M<91>.<91>f<8E>H@<CA><F8><9C>`<A4>\0@,       'Kopečná 20',   NULL,   '2012-10-18 18:56:05'),

which is clearly wrong and can't be imported.

When I dump the same data with mysqldump, the output is 
(1,'test','\0\0\0\0^A^A\0\0\0\r<91>.<91>f<8E>H@<CA><F8><9C>`<A4>\\0@','Kopečná 20',NULL,'2012-10-18 16:56:05'),
- the same data but quoted and with NULs and backslashes escaped. That can be imported.

Still present in 3.6.1.
Thanks

----------------------------------------------------------------------

>Comment By: himdel (himdel)
Date: 2012-11-22 04:43

Message:
Ok, any progress?

Since it appears that because phpmyadmin output, while techincally valid
SQL is not valid UTF-8 and thus can't be imported properly and while
mysqldump supports --hex-dump there's no way to do that for POINT ..
there's no sane way to actually dump a mysql table with POINTs anywhere
(except that I can use adminer to dump to csv and then translate that to
SQL so it can be imported again).

So I'll start working on a patch that makes adminer export POINT fields as
POINT(%F, %F) .

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3582578&group_id=264133