TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

About changing the order of latitude and longitude from MySQL8.0

Open goldpeace opened this issue 1 year ago • 0 comments

Please answer the questions below, it helps us to track the issue.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0):

MySQL Server version: 8.0.26 MySQL Community Server

  1. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):

TablePlus Version:5.8.0(256) - x64

  1. The steps to reproduce this issue:

Since MySQL8.0, there has been a change in the way latitude and longitude of the geometry type are saved, but when displayed on Tableplus, the display (longitude and latitude) is compliant with MySQL5.7.

  • Results obtained with MySQL client image

  • Results obtained with TablePlus DataView image

Reference materials:

https://github.com/Sequel-Ace/Sequel-Ace/issues/1509 https://note.com/moli9ma/n/n560e8141ad36

goldpeace avatar Jan 05 '24 05:01 goldpeace