we have a database of over 400000 products and are exporting them to google base. The thing is in certain products descriptions somehow there are charcacters such as â€™ inplace of a ' and characters â€“ inplace of |, etc which google doesn't like.
i used mysql REPLACE on these to switch them to their respective characters, but when i look at the output file they still show up there. This is when i run it from the shell or save the results to a file with >.
if i run a query with the mysql function i made to clean these in phpmyadmin everything looks fine.
any ideas here. by the way we didn't use a regular mysql connector like in php or something to run the query and go through the results because the results are very big and because of result caching this took a few hours to complete instead of a query in few seconds. if you run mysql from the shell with --quick this keeps from caching the results
Any ideas on how to get rid of these characters?
also we can't use outfile because the db server is a separate machine