Selecting a Point datatype from MYSQL

Question

Good Day,

I am trying to get a point from an SQL column. CUrrently it is encoded as a string of characters: Gþ`C@Ëóàî¬Ë]À

So is there any way to actually decode it to get the actual value?

Answer 1

Use MySQL's AsText() function:

SELECT AsText(myPoint) FROM myTable