Php-sql result in joomla displayed in question marks

Asked Apr 19 '18 at 06:46

Active Apr 19 '18 at 06:46

Viewed 18 times

I have a simple sql query, in a joomla php server, rs forms. The result contains Greek characters. However, the result is displayed in question marks.

$sql = "SELECT `FieldValue` FROM `table` where `FieldName` = 'age' and `SubmissionId` =   ".$submissionId."
";


$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) 

{ echo
     $row["FieldValue"] ; 
}

Result:

??? 20 ???? (question marks should be Greek letters)

I tried using convert as utf8, and it did not work. What else can i do?

  $sql = "SELECT CONVERT(`FieldValue` USING utf8) as `FieldValue`
  FROM `table` where `FieldName` = 'age' and `SubmissionId` =   ".$submissionId."";

asked Apr 19 '18 at 06:46

C Java

try putting charset=utf8 in your connection – Barclick Flores Velasquez Apr 19 '18 at 06:48
I dont think greek letters are part of UTF8 – Camille Apr 19 '18 at 06:48
make sure that in HTML head is also using UTF8 encoding – TIGER Apr 19 '18 at 06:50
Tried header('Content-type: text/plain; charset=utf-8'); did not change anything. No html, used, just php. – C Java Apr 19 '18 at 06:54

Php-sql result in joomla displayed in question marks

0 Answers0