[Skip to main content](#vessel-content) # Email history displays question marks instead of special characters ## - **[drop](/forum/user/46167-drop "View drop's Profile")** - [![drop's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46167-drop "View drop's Profile") Topic Author - [ Offline](/forum/user/46167-drop) Less More - Posts: 8 - Thank you received: 2 - - 3 years 3 months ago [\#352834](#352834) by [drop](/forum/user/46167-drop "View drop's Profile") *[Email history displays question marks instead of special characters](/forum/35-orders-management/906623-email-history-displays-question-marks-instead-of-special-characters#352834 "My e-mail notifications are set with UTF8 and base64 encoding. I use gmail smtp server for sending emails and customers get correct emails with correct special characters like āēļ etc. But when I...")* was created by *[drop](/forum/user/46167-drop "View drop's Profile")* My e-mail notifications are set with UTF8 and base64 encoding. I use gmail smtp server for sending emails and customers get correct emails with correct special characters like āēļ etc. But when I look at email history I see question marks instead of these characters. It seems that email history is only place where these question marks appear. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNjYyMy1lbWFpbC1oaXN0b3J5LWRpc3BsYXlzLXF1ZXN0aW9uLW1hcmtzLWluc3RlYWQtb2Ytc3BlY2lhbC1jaGFyYWN0ZXJzP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 3 years 3 months ago [\#352841](#352841) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Email history displays question marks instead of special characters](/forum/35-orders-management/906623-email-history-displays-question-marks-instead-of-special-characters#352841 "My e-mail notifications are set with UTF8 and base64 encoding. I use gmail smtp server for sending emails and customers get correct emails with correct special characters like āēļ etc. But when I...")* Hi, UTF8 and base64 encoding are the defaults. I have the same setup and the email don't have question marks in the history on my end, even though they also have special characters. I think that this issue is either: - you're using an old version of HikaShop where there is a bug on this - there is a problem with the hikashop_email_history table in your database. Maybe the tables were migrated at some point, or something, and the charset or collation of the table where the emails are stored for the history is not what it should be for some reason. In any cases, the email history area is usually not used much besides for debugging email issues. So it shouldn't matter that the preview of the emails sent has question marks there. I would just ignore the problem if I were you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNjYyMy1lbWFpbC1oaXN0b3J5LWRpc3BsYXlzLXF1ZXN0aW9uLW1hcmtzLWluc3RlYWQtb2Ytc3BlY2lhbC1jaGFyYWN0ZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drop](/forum/user/46167-drop "View drop's Profile")** - [![drop's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46167-drop "View drop's Profile") Topic Author - [ Offline](/forum/user/46167-drop) Less More - Posts: 8 - Thank you received: 2 - - 3 years 3 months ago [\#352924](#352924) by [drop](/forum/user/46167-drop "View drop's Profile") Replied by *[drop](/forum/user/46167-drop "View drop's Profile")* on topic *[Email history displays question marks instead of special characters](/forum/35-orders-management/906623-email-history-displays-question-marks-instead-of-special-characters#352924 "My e-mail notifications are set with UTF8 and base64 encoding. I use gmail smtp server for sending emails and customers get correct emails with correct special characters like āēļ etc. But when I...")* I checked hikashop_email_history table and there is latin1_swedish_ci collation set. If I try to change collation to utf8mb3_general_ci I get error (I really dont know much about how SQL works). How can I solve this? Maybe deleting whole hikashop_email_history table will help? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNjYyMy1lbWFpbC1oaXN0b3J5LWRpc3BsYXlzLXF1ZXN0aW9uLW1hcmtzLWluc3RlYWQtb2Ytc3BlY2lhbC1jaGFyYWN0ZXJzP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 3 years 3 months ago [\#352929](#352929) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Email history displays question marks instead of special characters](/forum/35-orders-management/906623-email-history-displays-question-marks-instead-of-special-characters#352929 "My e-mail notifications are set with UTF8 and base64 encoding. I use gmail smtp server for sending emails and customers get correct emails with correct special characters like āēļ etc. But when I...")* Hi, Yes. You can delete the whole table and click on the "check database" button of the HikaShop configuration. It should create it back with the correct collation. Best regards, Nicolas The following user(s) said Thank You: [drop](/forum/user/46167-drop "View drop's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNjYyMy1lbWFpbC1oaXN0b3J5LWRpc3BsYXlzLXF1ZXN0aW9uLW1hcmtzLWluc3RlYWQtb2Ytc3BlY2lhbC1jaGFyYWN0ZXJzP3RtcGw9bWFya2Rvd24=) 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.149 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)