ms access set charset utf-8 using pdo

Asked Feb 15 '17 at 12:11

Active Feb 16 '17 at 15:00

Viewed 878 times

I have a problem that made me crazy.
I connect to Access by this code:

$db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db_name; Uid=; Pwd=;"); 
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

When I want to insert data to access, data will be stored like Ú©Ø§Ù„Ø§. How can I set the charset to utf8??
I have tried some solutions but could not solve my problem.

edited Feb 16 '17 at 15:00

Option

2,605
2
19
29

asked Feb 15 '17 at 12:11

Farshad

and what are those solutions? – Masivuye Cokile Feb 15 '17 at 12:13
try this: `$db->query('SET NAMES utf8');` – SacrumDeus Feb 15 '17 at 12:45
i have tried this but not works :( – Farshad Feb 15 '17 at 19:01
Possible duplicate of [PHP PDO: charset, set names?](http://stackoverflow.com/questions/4361459/php-pdo-charset-set-names) – Option Feb 16 '17 at 14:39
@Option no doesnt work :( – Farshad Feb 21 '17 at 17:40

ms access set charset utf-8 using pdo

0 Answers0