Locale Pre-check SQL - Revision history

Alnaucler at 10:59, 8 March 2017

2017-03-08T10:59:21Z

← Older revision		Revision as of 12:59, 8 March 2017
Line 1:		Line 1:
	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.		The Locale fix tool has problems handling userenteredcoord with comma, dot or minus 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>		<pre>
Line 10:		Line 10:
	OR		OR
	geopoint.userenteredcoord LIKE '%.\|%'		geopoint.userenteredcoord LIKE '%.\|%'
			or
			geopoint.userenteredcoord LIKE '%-\|%'
	</pre>		</pre>

Alnaucler at 08:14, 8 April 2015

2015-04-08T08:14:47Z

@@ Line 10: / Line 10: @@
 OR
 geopoint.userenteredcoord LIKE  '%.|%'
 </pre>
 {{NavBox Upgrade}}

Alnaucler: 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..."

2015-04-07T19:16:58Z

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..."

New page

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]]