I don't care that i'm likely to get a few bumps on my head as i stumble about the room with severe sleep deprivation. Why not? because the euphoria of nailing a coding problem is something i forgot about. When all the total frustration and despair is vanquished...yep i got that joyous and triumphant feeling now.
I went to access the SQL window and documentation etc, but as has always been the case, simple links to pages were taking ten minutes to load or not at all.
Now one of the things i have been mightily impressed with since moving to WHUK is the 'Live Chat' facility. The operatives are head and shoulders over those in any service centre. I've reccommended WHUK to lots of people because of the ease in which one can obtain live help.
So i got in touch with them, now hopefully it's not a temporary fix because the servers will have a lighter load in the early hours but, they cleared some sort of jam causing the server to load slowly.
That meant i was able to just get right in there and work my socks off trying a myriad of combinations of quotes and brackets and syntax in the SQL window.
At first i thought this is insane as i pasted queries from the internal interface after using it's search/select facility and everything failed. To make matters worse was the bizzarre wording referring to terms i have never seen in php queries such as latin1_swedish_ci etc, also the operatives CONVERT and USING were inserted into the query - example below. It totally threw me.
SELECT *
FROM `table`
WHERE `SONG` LIKE CONVERT( _utf8 'love'
USING latin1 )
COLLATE latin1_swedish_ci
AND `ARTIST` LIKE CONVERT( _utf8 'beatles'
USING latin1 )
COLLATE latin1_swedish_ci
LIMIT 0 , 30
Anyway, once i catch up with things i have to do and get some sleep, i'll report back tomorrow with the solutions. It's a right old mix of removing quotes etc. and leaving some in there.
Many, many thanks for all help provided.
|