UTF-8 Access PDO PHP Arabic accdb

Asked Dec 12 '16 at 14:35

Active Dec 12 '16 at 15:22

Viewed 501 times

I'm facing a problem with PDO & Access using PHP

I have this code :

$query = "INSERT INTO work (".implode(",",array_keys($_POST)).") VALUES('".implode("','",$_POST)."')";
                                try{

                                $dbNew = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=".$dbA."; Uid=; Pwd=;charset=UTF8");
                                $queryaa = $dbNew->prepare($query);
                                $inst = $queryaa->execute();
                                } catch(PDOExepction $e){
                                echo $e->getMessage();
                                }

when i insert data to a MYSQL database , it gets saved correctly like :
Correct Form Of Data

But when i insert to Access database , it gets saved incorrectly as you can see here :

Incorrect Form of Data

So , how can i solve this problem?

edited Dec 12 '16 at 15:22

Blueblazer172

asked Dec 12 '16 at 14:35

Nizar

1

go through the link http://stackoverflow.com/questions/4229593/how-to-make-mysql-database-to-support-arabic-language – Karthikeyan Vivekanandhan Dec 12 '16 at 14:39
@KarthikeyanVivekanandhan I Already checked that , but how do i use UTF-8 for an Access Database? – Nizar Dec 12 '16 at 16:10

UTF-8 Access PDO PHP Arabic accdb

0 Answers0