Re: keymappings - PHP or MySQL?
| From: | Miguel Cruz | Date: | Mon, 29 Apr 2002 04:26:30 +0000 |
| Subject: | Re: keymappings - PHP or MySQL? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-95080@lists.php.net to get a copy of this message | ||
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