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?