PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Yes, I should be but I've googled my brains out and can't find any universal way to collate the query. Is there a way to detect what kind of collation they use before making the query?
I don't think there's a universal way of doing it. You could always collate both the column and the variable into the same encoding... then they'd always match. Might start being a bit slow though.
In retrospect, a google search for "show collation" would have worked much better than the "select collation" that I was using to search for how to do it
Thanks again,
-Cit
------------------------------
Edit: I cant seem to get this work using any combination of queries. Anyone know how to get the collation of a column using php and mysql?