Changes

Locale Pre-check SQL

425 bytes added, 21:16, 7 April 2015

Created page with "The Locale fix tool has problems handling userenteredcoord with comma or dot before the pipes e.g. -74:57:04,|06:06:16,5|es|ES|. The solution is to add a zero between the comm..."

The Locale fix tool has problems handling userenteredcoord with comma or dot before the pipes e.g. -74:57:04,|06:06:16,5|es|ES|. The solution is to add a zero between the comma/dot and the pipe.

<pre>
SELECT
geopoint.userenteredcoord
FROM
geopoint
WHERE
geopoint.userenteredcoord LIKE '%,|%'
OR
geopoint.userenteredcoord LIKE '%.|%'
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits