Charset Encoding PHP / MySQL

Question

I run a fantasy football management game and I'm in the process of adding multiple nationalities.

How can I set up PHP / MySQL to accept foreign characters (ALL TYPES). At the moment I'm trying to add Arabic but I'm not having much luck. Which encoding do I need to use and how do I make it work?

I've set both to UTF-8 unicode Please see here: http://www.footielegend.com/test/header.php

It stores it fine in the database.

Using UTF-8 all the way through - on the page, in the data base, in the database connection - is the required first step. Are you doing that? (The second step for Arabic is dealing with Right-To-Left script, which I don't have much experience with, but all the necessary information should be available on Stack Overflow already.) — Pekka
– Pekka, Commented Nov 22, 2011 at 23:41

DugoutSoccer · Accepted Answer · 2011-11-27 09:21:49Z

1

Figured it, I just needed to add this after I connect to the database:

mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");

answered Nov 27, 2011 at 9:21

DugoutSoccer

4225 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Diblo Dk Over a year ago

Maybe this assist you: stackoverflow.com/questions/845418/hsqldb-table-encoding/… stackoverflow.com/questions/7501924/… But as Pekka I't know much about Arabic, Chinese and Russian characters.

Alexey Gerasimov · Accepted Answer · 2011-11-22 23:42:56Z

0

Use UTF-8. Make sure your database collation is set to that (db, tables, and columns) and your php script also.

answered Nov 22, 2011 at 23:42

Alexey Gerasimov

2,14113 silver badges17 bronze badges

1 Comment

Alexey Gerasimov Over a year ago

@FootieLegend, what seems to be the problem then? You say it's storing fine in the database. Is it not displaying back properly?

Collectives™ on Stack Overflow

Charset Encoding PHP / MySQL

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related