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

Recommended Answers

Did you create your table like this?

CREATE TABLE t1
(
    col1 CHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci
)
Jump to Post

All 3 Replies

Did you create your table like this?

CREATE TABLE t1
(
    col1 CHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci
)

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

mysqli_set_charset($connnection,"utf8");

Be a part of the DaniWeb community

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