I have odd characters in my database that appeared after updating from a previous database. Most often the characters appear as simple squares where spaces should be. I've been trying to make a query that will find where all these characters appear in my table. The SQL looks like this:
SELECT * FROM tablename WHERE fieldname LIKE '% %' I end up getting hundreds of results (nearly all of them in the table). This is because the database returns everything with a space in fieldname. Does anybody know any methods of correcting this so that I can find where these squares occur? I've copied the character into a text editor that can display the hexidecimal value of the characters. The square character is different than a space, but for some reason when executing the SQL query it thinks they are the same. Any suggestions would be helpful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
