Hi,
I’m confused. I used so far in a very old template (from Expression Engine 1.7.x) the query module and it was working well with this version.
The same query in a template with EE 3.5.2 cannot handle the german umlauts. If I do instead work directly with PHP, the results are correct.
I don’t see any settings to configure the character set of the EE query.
=== the query part ===
{exp:query sql="SELECT OT FROM qa WHERE ID = '{segment_3}'"}
<h1>Details zu »{OT}«</h1>
{/exp:query}
… and the result is:
Details zu »Maigret und der hartnäckigste Gast der Welt«
=== the php part ===
<?php
if (ctype_digit({segment_3}))
{
$sql_q = "SELECT OT FROM qa WHERE ID = '{segment_3}'";
$pdo= new PDO('mysql:host=localhost;dbname=xx', $username, $db_pw);
$sql = $pdo->prepare($sql_q);
$sql->execute();
while($ae = $sql->fetch())
{
echo '<h1>Details zu »' . $ae['OT'] . '«</h1>';
}
}
?>
and the result is:
Details zu »Maigret und der hartnäckigste Gast der Welt«
What could be wrong?
Regards Oliver
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.