Forum

Posted: **11 Aug 2016, 20:29**

Hello!
I created a blog but I have problem with Romanian characters: autobelgia.ro/article.php?id=7

Posted: **12 Aug 2016, 07:28**

Hello
I see no problem with characters in that page. The romanian characters, diacritics, are displayed well.
Copied from that page:

mașină Începând cu data de 1 Mai 2016, Belgia a trecut la adoptarea placilor de tranzit în format european. Instituția

Anyway, if you have problems with diacritics or other less usual characters in your web page, follow these steps:
1. MySQL database must be created with this setting: utf8_general_ci
2. The tables in MySQL must be created having this instruction: CHARACTER SET utf8 COLLATE utf8_general_ci
3a. When it is created the connection with MySQLi, you must add the setting for UTF-8:

Code: Select all

$conn = new mysqli($host, $user, $password, $db_name);
$conn->query('SET character_set_client="utf8",character_set_connection="utf8",character_set_results="utf8";');

3b. Or, if you use PDO:

Code: Select all

$conn = new PDO('mysql:host='. $host .'; dbname='. $db_name, $user, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->exec('SET character_set_client="utf8",character_set_connection="utf8",character_set_results="utf8";');

4. In the php script you have to add header() function for UTF-8 (before displaying anything else, for example, after session_start()):

Code: Select all

header('Content-type: text/html; charset=utf-8');

5. The HTML page must have in the <head> area:

Code: Select all

<meta charset="utf-8" />

- If you follow these steps, the script should register and display well the diacritics and other less usual characters.

Forum

Problem with diacritics

Problem with diacritics

Problem with diacritics