ultimatehadow Posted July 14, 2009 Share Posted July 14, 2009 hi guys i got a question! i'm building a website on which i made a script to login using mail address and password in order to allow users to choose user names with strange characters but i have a problem about it cause when i insert a name like µltimãtê §haðøw in the db php inserts wrong chars and the same happens when i print those strings on the page.... my question is: in there a function which manages theese chars? otherwise i can make a function on my own but i need a hint... i don't know where to star from ??? Quote Link to comment https://forums.phpfreaks.com/topic/165925-manage-ascii-characters/ Share on other sites More sharing options...
phporcaffeine Posted July 14, 2009 Share Posted July 14, 2009 Your getting into the differences in character sets. You'll have the most difficulty with this when it comes to MySQL. My suggestion is to do an entity translation. I would take the ASCII character from the user input and translate it into the HEX equivalent and then store that into the database as a VARCHAR. Then when you pull it out of the database, translate it into the ASCII equivalent. Quote Link to comment https://forums.phpfreaks.com/topic/165925-manage-ascii-characters/#findComment-875152 Share on other sites More sharing options...
Adam Posted July 14, 2009 Share Posted July 14, 2009 Give htmlspecialchars() a try. Quote Link to comment https://forums.phpfreaks.com/topic/165925-manage-ascii-characters/#findComment-875153 Share on other sites More sharing options...
ultimatehadow Posted July 14, 2009 Author Share Posted July 14, 2009 MrAdam u rock! perfect it works within the html context, now i'm gonna try it with mysql! thanks a lot!!!! Quote Link to comment https://forums.phpfreaks.com/topic/165925-manage-ascii-characters/#findComment-875156 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.