Building a login form with arabic input. How to match records

Question

I am building a form using PHP and I want the user to login with his Arabic name. I have set the database to UTF-8 and the column to UTF-8.

And I have enter the following code in my PHP script:

header('Content-Type: text/html; charset=UTF-8');

And when I output the result it is written in arabic, so no junk letters ...

Why it doesn't log me in when I use arabic username and when I use english username it logs me in?

"Login" -- Do you mean via MySQL's login? Or code you wrote? — Rick James, Sep 13 '16 at 16:11
@RickJames I don't think the problem is with character set to UTF-8. Because when I output my text field value I get Arabic characters. But it won't log me in if I use an Arabic username. And it works with english usernames and email address. What do you think is the problem? — FarrisFahad, Sep 13 '16 at 17:56
If utf8 is stored in a latin1 column, it will _appear_ to be correct when displayed, while still being stored incorrectly. — Rick James, Sep 13 '16 at 18:35
Please provide `SHOW CREATE TABLE` for the table where the user name is stored. — Rick James, Sep 13 '16 at 18:35
@RickJames I don't understand. What you mean by `SHOW CREATE TABLE` — FarrisFahad, Sep 13 '16 at 19:55

score 0 · Answer 1 · edited May 23 '17 at 12:01

0

A few things to check:

What is your database encoding? Maybe you input is utf-8, but it has been transformed into something else :)
1. Check your framework (if you are using any) - maybe there is a build in mechanism to transform this
2. Do you use mysqli to connect? I bet you do - try PDO instead
3. There is a small discussion here about similar topic: log in with Arabic characters

edited May 23 '17 at 12:01

Community

answered Sep 13 '16 at 06:51

Bogo

my database encoding is UTF-8. When I out put the username in login script, the arabic characters are shown correct, so there is no problem there. But I can't login with an Arabic username, on the other hand, it works great with English username. What do you think is the problem? – FarrisFahad Sep 13 '16 at 18:02

1 Answers1