New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

字段polygon,类型geometry存在数据截断问题 #40

Open

Voccoo opened this issue Feb 29, 2024 · 1 comment

Voccoo commented Feb 29, 2024

在使用测试版本的数据导出成sql后，通过navicat直接导入到mysql 8.0.34，因为默认设置的字段长度为65535，因此多数的省直辖市的polygon的内容，都是在这个长度后被截断了。比如北京是在40.977926, 116.494002 40.9截断。
大佬有什么解决方式吗？

Owner

xiangyuecn commented Mar 1, 2024

只是你的客户端显示被截断了而已，实际存储的geometry类型是没有长度限制的

你可以客户端查询后，导出数据，或者选中一行数据复制insert语句，可以看到完整内容

非客户端，用其他语言调用时，不存在这种截断显示的问题

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment