[Skip to main content](#vessel-content) # csv import special characters ## - **[Kerstin](/forum/user/17808-kerstin "View Kerstin's Profile")** - [![Kerstin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17808-kerstin "View Kerstin's Profile") Topic Author - [ Offline](/forum/user/17808-kerstin) Less More - Posts: 14 - Thank you received: 0 - - 13 years 5 months ago [\#104982](#104982) by [Kerstin](/forum/user/17808-kerstin "View Kerstin's Profile") *[csv import special characters](/forum/4-how-to/82392-csv-import-special-characters#104982 "Hi! I didn't find the right topic, so created a new one. Export and import work. But even when I export and don't open the exported csv (just save)and try to reimport it, I get an error message (The column 'gr���e' is not in the list of possible columns ...). Should look like: "Größe" (german) I tried it with utf-8 and with unknown. Thanks in advance Kerstin")* was created by *[Kerstin](/forum/user/17808-kerstin "View Kerstin's Profile")* Hi! I didn't find the right topic, so created a new one. Export and import work. But even when I export and don't open the exported csv (just save)and try to reimport it, I get an error message (The column 'gr���e' is not in the list of possible columns ...). Should look like: "Größe" (german) I tried it with utf-8 and with unknown. Thanks in advance Kerstin Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgyMzkyLWNzdi1pbXBvcnQtc3BlY2lhbC1jaGFyYWN0ZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 13 years 5 months ago [\#104999](#104999) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[csv import special characters](/forum/4-how-to/82392-csv-import-special-characters#104999 "Hi! I didn't find the right topic, so created a new one. Export and import work. But even when I export and don't open the exported csv (just save)and try to reimport it, I get an error message (The column 'gr���e' is not in the list of possible columns ...). Should look like: "Größe" (german) I tried it with utf-8 and with unknown. Thanks in advance Kerstin")* Hi, Please do not use special characters for table columns in your database but only latin letters without accents. Databases do not handle well special characters in column names and there is no point in doing that since the column name is never displayed to the user. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgyMzkyLWNzdi1pbXBvcnQtc3BlY2lhbC1jaGFyYWN0ZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Kerstin](/forum/user/17808-kerstin "View Kerstin's Profile")** - [![Kerstin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17808-kerstin "View Kerstin's Profile") Topic Author - [ Offline](/forum/user/17808-kerstin) Less More - Posts: 14 - Thank you received: 0 - - 13 years 5 months ago [\#105015](#105015) by [Kerstin](/forum/user/17808-kerstin "View Kerstin's Profile") Replied by *[Kerstin](/forum/user/17808-kerstin "View Kerstin's Profile")* on topic *[csv import special characters](/forum/4-how-to/82392-csv-import-special-characters#105015 "Hi! I didn't find the right topic, so created a new one. Export and import work. But even when I export and don't open the exported csv (just save)and try to reimport it, I get an error message (The column 'gr���e' is not in the list of possible columns ...). Should look like: "Größe" (german) I tried it with utf-8 and with unknown. Thanks in advance Kerstin")* I got it It was the name of a characteristic now I use the alias Thank you very much Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgyMzkyLWNzdi1pbXBvcnQtc3BlY2lhbC1jaGFyYWN0ZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.078 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)