Problem with Unicode registered in Access database

Mehraban · Post by **Mehraban** » Sat May 04, 2019 1:07 am

Hello friends

Information is entered correctly at the time of data recording on a web page made with PHPMaker.
But when accessing the access information, the information is displayed as follows.
Ø¯ÙˆØ³ØªÛŒ Ùˆ Ù…ØØ¨Øª=
ÛŒØ¸â€žØºÅ’Ø¸Ù¾Ø·Â§Ø¸â€

How is it possible to store the information in the database tables correctly? (utf-8)

It is noteworthy:
I made this change in the character limit that I created in the Open Source file.

arbei · Post by **arbei** » Sat May 04, 2019 10:08 am

Make sure the charset of your project is "utf-8".

Mehraban · Post by **Mehraban** » Sat May 04, 2019 4:21 pm

Yes of course
I changed the following to "utf-8":

HTML > Charset = utf-8
Tools > Advanced Settings > Chatacter encoding (for Ajax/iconv) = utf-8
Tools > Advanced Settings > MYSQL Charset (for SET NAMES) = utf-8

Is there another case for review?

Of course I looked at the source page and the following meta tag was in the header section:
<meta charset="utf-8">

mobhar · Post by **mobhar** » Mon May 06, 2019 9:31 am

Make sure your database charset is utf-8, too.

Mehraban · Post by **Mehraban** » Mon May 06, 2019 9:15 pm

Thank you
My Database is MS Access!

Unfortunately, MS Access does not have the ability to select Unicode!
A solution to your mind?

mobhar · Post by **mobhar** » Mon May 06, 2019 11:14 pm

Not sure whether MS Access Database already supports utf-8 by default. Please try to Google it.