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
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?
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