![]() ![]() For example, you can set it to "nb_NO.UTF-8" to match your other nb_NO.UTF-8 settings. You can try changing the LC_CTYPE setting to a Nordic UTF-8 locale to see if it resolves the issue. However, the LC_CTYPE category may be set to "en_US.UTF-8", which might not be compatible with the Nordic characters you mentioned. To work with UTF-8 characters in the SQLite command-line tool, you need to make sure that your terminal and locale settings are properly configured.īased on the output of the locale command you provided, it seems that your locale settings are already set to use UTF-8 encoding ( en_US.UTF-8) for most categories. My language being eng-us.utf8 might explain it? I will change and update this post if that fixes it. Is there a way to work with sqlite3 and utf-8 characters in terminal? I work in ubuntu and use SQLite version 3.32.3.īy suggestion of Kanavos I ran $ locale output: ![]() If I open up sqlite3 or any sqlite3 database in terminal and try to press any of “æøå” (nordic characters) none of them register as in the shell. While I have seen that you can have utf-8 encoding in sqlite3, which I guess would enable you to ingest and store data that is utf-8 encoded, it seems like it is not possible to use sqlite3 command tool with sqlite3 characters and thus in essence making it very hard to work with utf-8 data (let alone column names, just filtering data is implossible).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |