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:mnc@stoic.net] > 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 baldey_uk@softhome.net gets stored in > the > > database as baldey\uk@softhome.net. 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 > > >