Postgresql changes letter with accent

Question

Look I’m saving data on SGBD Postgresql, only that the data (NAME, CITY, STREET), I am saving in capital to facilitate when searching.

He’s saving normal, the problem is that when I save a word in capital letters and accent, the Postgresql turns the letter into a lower case.

  $nome = strtoupper($cliente->getNome());
        $cpf = $cliente->getCpf();
        $endereco = $cliente->getEndereco();
        $cidade = strtoupper($endereco->getCidade());
        $rua = strtoupper($endereco->getRua());
        $numero = $endereco->getNumero();
        $telefones = $cliente->getTelefones();
        $telefone1 = $telefones[0];
        $telefone2 = $telefones[1];

      $valorArmazenar = $this->conexao->prepare("INSERT INTO cliente(nome_cliente,cidade, rua, numero, telefone1, telefone2, cpf) VALUES(:nome,:cidade,:rua,:numero,:telefone1,:telefone2, :cpf)");

      $valorArmazenar->bindValue(":nome", $nome);
      $valorArmazenar->bindValue(":cidade", $cidade);
      $valorArmazenar->bindValue(":rua", $rua);
      $valorArmazenar->bindValue(":numero",$numero);
      $valorArmazenar->bindValue(":telefone1", $telefone1);
      $valorArmazenar->bindValue(":telefone2", $telefone2);
      $valorArmazenar->bindValue(":cpf", $cpf);
      $valorArmazenar->execute();

See that the "A" of the word JOHN he left John "A" in tiny, and this makes it difficult at the time of my search by the record.

Answer 1

This is because strtoupper failed to turn the accented letter to uppercase, in this case use the mb_strtoupper in place.

$nome      = mb_strtoupper($cliente->getNome(), 'UTF-8');
$cpf       = $cliente->getCpf();
$endereco  = $cliente->getEndereco();
$cidade    = mb_strtoupper($endereco->getCidade(), 'UTF-8');
$rua       = mb_strtoupper($endereco->getRua(), 'UTF-8');
$numero    = $endereco->getNumero();
$telefones = $cliente->getTelefones();
$telefone1 = $telefones[0];
$telefone2 = $telefones[1];

Clicking here to understand more about the case.

Tip

Whenever possible create your database in ENCODING UTF8, LC_COLLATE en_US.UTF-8 and LC_CTYPE en_US.UTF-8, otherwise you may have this type of problem and others like sort an alphabetic query and it brings first those that start with lowercase letters and then those that start with uppercase letters (or the opposite, I don’t remember).

Answer 2

If your Postgresql has LATIN1 chartset support, just recreate the database with the following features:

    CREATE DATABASE nome_do_banco ENCODING 'LATIN1' LC_COLLATE 'pt_BR.ISO-8859-1' LC_CTYPE 'pt_BR.ISO-8859-1' template template0;

Take the test again and see how it turned out.