search

Zeeshanahmad4 / Zip-code-of-all-countries-cities-in-the-world-CSV-TXT-SQL-DATABASE

Zip code of all countries in the world along with cities in CSV, TXT, SQL DATABASE
62 stars 12 forks source link

Incorrect characters sqlite File #1

Closed au-lait77 closed 4 years ago

au-lait77 commented 4 years ago

In the SQLite DB, specifications with special characters are incorrect. See screenshot. There the characters ÖÄÜ are destroyed. in the TXT file everything is correct Can u fix it?

image

Zeeshanahmad4 commented 4 years ago

You need to edit your SQL encoding. On Thu, Aug 27, 2020, 15:01 TheCatcher99 notifications@github.com wrote:

In the SQLite DB, specifications with special characters are incorrect. See screenshot. There the characters ÖÄÜ are destroyed. in the TXT file everything is correct Can u fix it?

[image: image] https://user-images.githubusercontent.com/13865833/91426393-c05a4c80-e85c-11ea-802f-e815ab1917c8.png

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Zeeshanahmad4/Zip-code-of-all-countries-cities-in-the-world-CSV-TXT-SQL-DATABASE/issues/1, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIXBJDDBUCG353PV5A54VEDSCYVJLANCNFSM4QMZUCKQ .