3

First I have issues when I post UTF-8 characters on MS ACCESS (mdb) database via PHP.

After I'm converting enconding to ISO-8859-1 to show characters correctly from database.

But I didn't like this solution.

If I can change Access Encoding my problem is solved. If not, I still stay with my bad solution.

philshem
  • 23,689
  • 7
  • 58
  • 120
Joao Paulo
  • 1,033
  • 3
  • 17
  • 34
  • possible duplicate of [How to convert MS Access database encoding to UTF-8?](http://stackoverflow.com/questions/5222705/how-to-convert-ms-access-database-encoding-to-utf-8) – Laurent S. Nov 22 '13 at 13:19
  • @Bartdude, In that question nobody says if is possible to change MS ACCESS database – Joao Paulo Nov 22 '13 at 13:29
  • Well the second answer may well help you. it would also help to know which version of access we're talking about. Probably < 2007 as the default encoding from there is UTF-8 AFAIK – Laurent S. Nov 22 '13 at 13:35
  • @Bartude, I'm already converting character encoding into php. What I want is to know if is possible to convert my database file permanently. – Joao Paulo Nov 22 '13 at 13:40
  • 1
    I had a similar problem a while back and the only way I could get it to work was to use ADO as described [here](http://stackoverflow.com/a/19906108/2144390). (I couldn't get either PDO-ODBC or legacy PHP ODBC support to work with UTF-8 characters in Access.) – Gord Thompson Nov 22 '13 at 14:50

2 Answers2

1

Thank you all for attention and suggestions. I think there is no way to do what I want.

Joao Paulo
  • 1,033
  • 3
  • 17
  • 34
0

In vb

x = StrConv(MyText, vbFromUnicode)

Or In sql

StrConv(MyText, 64)

But befor send your data with php you can convert charset of text by using iconv function or other php functions.

hhaseli
  • 37
  • 3