Re: [PHP] keymappings - PHP or MySQL?
On Mon, 29 Apr 2002, baldey_uk wrote: At the moment im getting a difference in keymappings between what is typed into a field and what is stored in the database. I have an html form that gets a text string called $email and this is inserted into a VARCHAR database feild via php, the problem is when special characters are included in the email address. For example [EMAIL PROTECTED] gets stored in the database as baldey\[EMAIL PROTECTED] Has anyone seen this before? Is this a PHP or mysql issue? Do i have to set special options to use a UK keymap or something like that? If anyone has any links to docs that deal with this sort of thing i'd really appreciate them!! You might want to do some detective work to hone in on what's really going on. Before storing the string into the database, print out the actual numeric code for each character by looping over the string with ord(). Then do the same when you pull the data out of the database. Hopefully that'll help narrow down where this is happening. miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] keymappings - PHP or MySQL?
Thanks for the suggestion Miguel, i tried it and got a result of 95 on both tests which is the underscore character. bizare Cheers Baldey_uk -Original Message- From: Miguel Cruz [mailto:[EMAIL PROTECTED]] Sent: 29 April 2002 05:27 To: baldey_uk Cc: Php-General Subject: Re: [PHP] keymappings - PHP or MySQL? On Mon, 29 Apr 2002, baldey_uk wrote: At the moment im getting a difference in keymappings between what is typed into a field and what is stored in the database. I have an html form that gets a text string called $email and this is inserted into a VARCHAR database feild via php, the problem is when special characters are included in the email address. For example [EMAIL PROTECTED] gets stored in the database as baldey\[EMAIL PROTECTED] Has anyone seen this before? Is this a PHP or mysql issue? Do i have to set special options to use a UK keymap or something like that? If anyone has any links to docs that deal with this sort of thing i'd really appreciate them!! You might want to do some detective work to hone in on what's really going on. Before storing the string into the database, print out the actual numeric code for each character by looping over the string with ord(). Then do the same when you pull the data out of the database. Hopefully that'll help narrow down where this is happening. miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] keymappings - PHP or MySQL?
Next thing, I guess, would be to check the character encoding in use to display the character. Your browser might have a menu somewhere that tells you what it's using. 95 is the underscore in standard ASCII, after all. miguel On Mon, 29 Apr 2002, baldey_uk wrote: Thanks for the suggestion Miguel, i tried it and got a result of 95 on both tests which is the underscore character. bizare Cheers Baldey_uk -Original Message- From: Miguel Cruz [mailto:[EMAIL PROTECTED]] Sent: 29 April 2002 05:27 To: baldey_uk Cc: Php-General Subject: Re: [PHP] keymappings - PHP or MySQL? On Mon, 29 Apr 2002, baldey_uk wrote: At the moment im getting a difference in keymappings between what is typed into a field and what is stored in the database. I have an html form that gets a text string called $email and this is inserted into a VARCHAR database feild via php, the problem is when special characters are included in the email address. For example [EMAIL PROTECTED] gets stored in the database as baldey\[EMAIL PROTECTED] Has anyone seen this before? Is this a PHP or mysql issue? Do i have to set special options to use a UK keymap or something like that? If anyone has any links to docs that deal with this sort of thing i'd really appreciate them!! You might want to do some detective work to hone in on what's really going on. Before storing the string into the database, print out the actual numeric code for each character by looping over the string with ord(). Then do the same when you pull the data out of the database. Hopefully that'll help narrow down where this is happening. miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php