Member Avatar for Rizi004

Hi everyone.

I want to store greek letters in mysql table my table collaction is utf8_general_ci and i'm calling this function after database connection

mysqli_query($connection, "SET NAMES 'utf8'");
mysqli_query($connection,"SET CHARACTER SET 'utf8'");

but all greek letters in database are like "??????? ???" Question mark how to resolve this ???

I search on internet and eveyone says set characterset that i also set even in my html page i also have this line
<meta http-equiv="content-type" content="text/html; charset=UTF-8">

someone says change utf8_general_ci to greek_general_ci but still have same problem

Regards
Rizwan

  • 3 Contributors
  • 3 Replies
  • 266 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by almostbob
Member Avatar for DaveAmour

Did you create your table like this?

CREATE TABLE t1
(
    col1 CHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci
)
Member Avatar for Rizi004

i attached the table image i haven't created the table with query i created in PHPmyAdmin table.JPG

Member Avatar for almostbob

mysqli_set_charset($connnection,"utf8");

Edited by almostbob
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.