Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Daevid Vincent (daeviddaevid.com)
Date: Mon Dec 08 2008 - 19:27:02 CST
Also, I realize you're trying to 'encode' some sort of X\Y\Z coordinates
in that column, so perhaps a different delimiter such as the pipe "|"
character or "," would be more appropriate than a \ which has special
Or possibly just split them out into separate X, Y, Z columns rather
than cramming them together like that. This would allow you to do
various trig and math functions on them easier (assuming you are storing
coordinates for a reason).
There are basic SQL 'update' statements you could write to fix your
existing data and/or convert it to the new delimiter. This may save you
headaches going forward.
On Tue, 2008-12-09 at 12:42 +1300, SolidEther wrote:
> I'm trying to compare strings on a varchar field.
> The code: 'select * from Image where `0020,0032`="-131.178600\
> \107.113725\\200.064000";' returns the correct result set.
> However, the code: 'select * from Image where `0020,0032` LIKE
> "%-131.178600\\107.113725\\200.064%";' returns an empty set, and so
> does 'select * from Image where `0020,0032` LIKE "-131\.178600\\107\.
> I can't really figure out why, can anyone explain?