At 15:56 +0200 25/4/06, Barry wrote:
Updating is always such a bad idea ;P Do you know: never touch a running system? ^_^
Hmmm...
And you don't see any misdone queries when you echo them, right? Hope you checked that.
Yes, they look just fine - in any case they're unchanged from when it was working perfectly in 3.23
ENCODE = NOT CODED into CODED DECODE = CODED into NOT CODED So encode the input into query and encode it afterwards :)
Yes, tried that - no good. In any case...
At first I thought the upgrade or utf8 might be having some effect on the way "like '%...%'" works, but another simpler search uses that and it's fine.
...there's no en/decoding involve there and it works fine.
So in simple words. You tried also to query the Table without encoding it first into UTF-8?
With and without. But anyway, as I understand it, something like 'olympic' or 'london' (another thing I'm test-searching for because just about every guide mentions London somewhere in their biography - they're London guides, see? :-) ) is the same whether or not it's encoded... no?
There are various, and the main spot here is the ENCODING of UTF-8.
That's more or less the conclusion I've come to as well, but I can't seem to make a difference whichever way round I do it. I'm also wondering now if it might be a PHP issue after all - something I've missed about form input, but I realise this list isn't the right place to follow that up.
More infos will be great. It surely is tricky.
Yep.
I am not quite sure but using biography.guide_id instead of b.guide_id would probably solve the problem. I know that using aliases in WHERE clauses don't work really good, so try this also please.
OK, I have, and it still makes no difference. Anyway, I reiterate: it worked perfectly in 3.23.x - surely something basic like this couldn't have got /worse/ through the version upgrades? And for what it's worth I tried taking the 'as' out too, which I gather is now optional - no diff.
-- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Star Wars won't work. -- Frank Zappa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
