collation creates problem
I install mysql in local pc ... it uses latin... collation
i install same database on web server and i use same .php file to fire query on mysql with collation contained query ... it gives me error ... because the web server may uses different collation
i want to use same sql query in both ... my local installation and web serve...
what can i do ?
example ...
SELECT * FROM ambicaitem
WHERE product LIKE CONVERT( _utf8 'myProd' USING latin1)
COLLATE latin1_swedish_ci
Subject
Written By
Posted
collation creates problem
April 26, 2005 03:13PM
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.