search

islamic-network / api.alquran.cloud

The AlQuran.Cloud API - https://alquran.cloud/api
GNU General Public License v3.0
226 stars 41 forks source link

What collation to use for arabic in database? #15

Closed kickthemooon closed 5 years ago

kickthemooon commented 5 years ago

May Allah reward you with Jannah Firdaws for the api.

I am having problems when importing the arabic ayat text from the api into my database.

Example surah Ash-Shams...

api: وَالشَّمْسِ وَضُحَاهَا

in my database: وَٱلشَّمْسِ وَضُحَىٰهَا

the problem is with the the Haa Haa in Duhaahaa, specifically with the first Haa in Duhaahaa.

I dont know what the problem is but i am thinking it has something to do with the collation my database is using (charset: utf8mb4; collation: utf8mb4_unicode_ci).

So I was wondering what collation are you using?

And do you know what the problem here is?

JazakAllah Khair.

meezaan commented 5 years ago

Alaykum Salaam brother.

What edition are you using?

It appears you are checking different editions via the api and the database.

Any of the utf8's should be fine. The docker image uses utf8_general_ci.