Forum Moderators: open
I have a MySQL database, containing a row with a value of l for lion (lower case). Now when I do a simple retrieve and display it looks like an l for lion (choosing an appropriate font). All ok.
If I copy and paste from Firefox, it still comes back as an l for lion. So still ok.
Anyway... if I use mail() to read this row and then send this to an email address (in this case at gmail) it displays as l in gmail - ambiguous because gmail displays l (lion) and I (Indigo) the same.
So I cut and pasted it from gmail, and in fact although it was sent as an l (for lion) it repastes everywhere as an I (Indigo).
Also, if I use phpmyadmin and cut and paste in Firefox, and repaste elsewhere it also copies as a capital I (for Indigo).
But it's in the database as an l (for lion), I can see it is an l and can prove so with a script or with an appropriate font on the display.
Why does this happen?
I'm waiting for someone to say, d'uh that's obvious silly, but I've been thinking about it all morning. Any pointers would be most appreciated.
(the background to this is that people with an l in their autogenerated password cannot cut and paste when they first sign in because it gets changed to an I and hence does not match the user database!)
Other than that, I'm baffled too, but ...
I have a vague idea that when a browser posts text, the charset of the page can affect things - but I can't see how this would apply in your case.
Kaled.
