Accentuation problem while recovering records in SQL Server

Question

When I recover records from a SQL Serve database with PHP errors appear in accentuation.

But in the database, the accents are correct. Is there any way to handle this with PHP? I don’t have permissions to change the collation bank.

Collation of the bank: Latin1_general_ci_as

File connection to the bank:

$host='xxxxxx';
$user='xxxxx';
$database='xxxxx';
$pass='xxxxx';

$con=mssql_connect($host, $user, $pass) or die ("Erro de conexão com o banco de dados"); 
mssql_select_db("$database") or die ("Erro ao selecionar banco de dados");

Fields on the bench:

Result of PHP query

Answer 1

I found the solution to this problem in a very simple way. When printing the string, I used the function before

utf8_encode($variavel_contendo_string)

and the problem was solved!

This function encodes the string to utf-8.

Answer 2

Try to use the same Collation throughout your application.

Since you cannot change the Database, set up PHP to work with Latin-1 (ISO-8859-1):

header('Content-Type: text/html; charset=iso-8859-1');

Or in the file php.ini

default_charset = "iso-8859-1"

In addition to PHP and Database configuration, you need to change the charset of your pages to work with ISO-8859-1 instead of UTF-8.

Answer 3

You can use the PHP function:html_entity_decode($valor);

Answer 4

You can use sqlsrv_connect in which the parameter exists CharacterSet UTF-8.

$host="xxxxxx";
$user="xxxxx";
$database="xxxxx";
$pass="xxxxx";

$connArr = array(
    "Database"     => $databae,
    "UID"          => $user,
    "PWD"          => $pass,
    "CharacterSet" => "UTF-8"
);

$conn = sqlsrv_connect($host, $connArr) or die("Erro de conexão com o banco de dados");

Answer 5

1st Alternative:

Open the file .php on Notepad++ and go to menu button formatar and select the option: Codificação em UTF-8 (sem BOM), it is possible that the PHP source file is not utf-8.

2nd Alternative:

The page .html which is rendering not in the standard utf-8, so add this line to it:

<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">

3rd Alternative:

Add this at the beginning of your file .php

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

4th Alternative:

Add the following line to the file .htaccess

AddDefaultCharset UTF-8

5th alternative:

Edit the following line in the file php.ini to stand as below:

default_charset = "UTF-8"

6th Alternative:

If you don’t have access to the file php.ini add the next line at the top of the document .php:

ini_set('default_charset', 'UTF-8');

7th Alternative:

ini_set('mssql.charset', 'UTF-8');

Answer 6

There are answers that already make a good instruction on how to model your application for the same encoding of the database.

However, I want to leave my answer to be used by those who want to keep their application in UTF-8and use a database in different coding.

Convert the data in time to fetch using overload, as in this example:

class DrivePDOUtf8 extends DrivePDO
{
    protected function toUtf8($dados)
    {
        if (is_array($dados) || is_object($dados)) {
            foreach ($dados as $i => $r) {
                if (is_array($r) || is_object($r)) {
                    $dados[$i] = $this->toUtf8($r);
                } else {
                    $dados[$i] = utf8_encode($r);
                }
            }
        } else {
            $dados = utf8_encode($dados);
        }

        return $dados;
    }

    public function fetch($sql, $mode = null, $all = false)
    {
        $fetch = parent::fetch($sql, $mode, $all);

        return  $this->toUtf8($fetch);
    }
}