Accent error in PHP x MYSQL, using UTF8_encode() and UTF8_decode()?

Question

I am having problems with accentuation in a project that I am giving maintenance.

Table MYQL using utf8_unicode_ci

String Error

$text = 'SÃ£o Josï¿½'; #correct São José
echo utf8_decode($text); #print São Jos�
echo utf8_encode($text); #print SÃÂ£o JosÃ¯Â¿Â½

How to solve using php 5.6?

Hex `EFBFBD` represents the "Replacement Character". In certain situations, it shows as `ï¿½`. So, I suspect you mangled the data in an attempt to fix it, and now there are _two_ errors to undo. You will probably have to start over and establish the use of utf8 (or utf8mb4) and several points in your code. — Rick James, Dec 03 '18 at 23:45

score 1 · Answer 1 · answered Dec 03 '18 at 13:15

1

Before you fetch result from the database, fire below query,

SET NAMES UTF8;

This will set the character-set and the results returned will be proper.

answered Dec 03 '18 at 13:15

Samir Selia

1 Answers1