PHP/MySQL storing unusual characters!
Posted: Tue Mar 16, 2010 12:06 pm
Greetings:
I have a regex that goes through some source code and finds 3 - Attached and stores it as $garage_spaces. If I then do an echo $garage_spaces, I don't have the but just a space. That's fine enough. When I insert this into a MySQL table, it just looks like "3 - Attached" which is again fine. However, when I do a select and pull the garage field, I get weird ascii characters instead of the spaces. It looks like 3�-�Attached for some reason. It is driving me nuts! Anybody know what I'm doing wrong or what I could try to do to fix this?
Thank you so much!
I have a regex that goes through some source code and finds 3 - Attached and stores it as $garage_spaces. If I then do an echo $garage_spaces, I don't have the but just a space. That's fine enough. When I insert this into a MySQL table, it just looks like "3 - Attached" which is again fine. However, when I do a select and pull the garage field, I get weird ascii characters instead of the spaces. It looks like 3�-�Attached for some reason. It is driving me nuts! Anybody know what I'm doing wrong or what I could try to do to fix this?
Thank you so much!