Issue with converting text to Latin

94 Views Asked by At

Need to convert below string from UTF-8 to Latin (ISO-8859-1)

Häger

The correct output should be: Häger

I have tried this by PHP and MySQL but did not get the desired result.

PHP:

<?php
$text = "Häger";
$text= utf8_decode($text);
echo $text;
?>

Output : H�������¤ger

MySQL:

select CONVERT(CAST(CONVERT('Häger' USING latin1) AS binary) USING utf8)

Output : H���¤ger

Can someone please help here?

0

There are 0 best solutions below