Well, working in MySQL Query Browser, but not in PHP...
If I run this query in Query Browser:
SELECT * FROM view_cl_all WHERE (cl_name LIKE '%ab%' COLLATE utf8_general_ci)
it works (5 results). If I run the same query in PHP, query fails. But
SELECT * FROM view_cl_all WHERE (cl_name LIKE '%ab%')
is working both in Query Browser and PHP.
Is there a collate problem with PHP ?!?!?!
Subject
Views
Written By
Posted
11814
July 22, 2006 04:33AM
4226
July 22, 2006 06:05AM
3978
July 25, 2006 08:18AM
3944
July 26, 2006 01:43AM
3509
July 26, 2006 01:08PM
3446
July 26, 2006 11:29PM
3211
July 26, 2006 11:40PM
3174
July 26, 2006 11:51PM
Well, working in MySQL Query Browser, but not in PHP...
3171
July 27, 2006 12:49AM
5215
July 27, 2006 01:21AM
2732
July 28, 2006 03:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.