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
