orders with a character "é" are incorrect

Author	« Topic »
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/05/2026 : 13:49:29 Any order with an "é" character is coming in the admin as the character #65533;. $adminencoding="UTF-8"; is set in the includes Some background is that we did just move to a new server. Not sure if that's the problem, and not sure how to check? Here is what my web guy added to the db connect file to fix the R and TM issue in the descriptions. $GLOBALS['ectdatabase']->set_charset('utf8mb4'); // <-- add this line Edited by - steven vaccaro on 08/05/2026 14:47:33
Vince Administrator 43508 Posts	Posted - 08/07/2026 : 11:56:34 Hi Steven Are you sure you are using UTF-8 in both your web pages and admin pages? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/09/2026 : 18:04:14 Yes Vince
Vince Administrator 43508 Posts	Posted - 08/11/2026 : 05:51:55 In that case has your web guy checked that the actual database tables are in UF8? If they are all using the same character set it's normally ok. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/11/2026 : 05:56:18 Ill have him look, thanks
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/11/2026 : 06:18:34 He sent me this.
Vince Administrator 43508 Posts	Posted - 08/11/2026 : 06:19:41 Hi Steven There seems to be a problem on your website at the moment as the css/ectcart.css file is missing. It's really hard to navigate the site at the moment. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/11/2026 : 06:21:30 That's odd; it's been working fine with orders and such. I'll ask the web guy.
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/11/2026 : 06:57:47 Vince, he reuploaded the CCS directory, but it's still acting strange.
Vince Administrator 43508 Posts	Posted - 08/12/2026 : 03:02:43 Hi Steven Ok, that looks better now so I guess the ectcart.css file is back. But really, the only thing left is the database itself which I assume your database guy has looked at to make sure it is using an UTF8 encoding. You really need to get in touch with your host if it is still garbling characters as I'm not sure what it would be if all parts of the system are using UTF8. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/12/2026 : 21:24:05 Vince, this is his response, I can change this NP. I just want to make sure it gets set to the correct Collation. There is no UTF8 that I can see. Tons of utf8mb3xxx and utf84xxx
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/17/2026 : 07:08:46 Anyone have any thoughts on this?
Vince Administrator 43508 Posts	Posted - 08/18/2026 : 01:59:49 Hi Steven I just did a quick check in Google and this is what the AI overview says... quote: For most modern applications using MySQL 8.0 or newer, you should use utf8mb4_0900_ai_ci along with the utf8mb4 character set. If you are using an older version of MySQL (like 5.7), use utf8mb4_unicode_520_ci or utf8mb4_unicode_ci Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/18/2026 : 08:10:53 Thanks, we will try that.
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 08/31/2026 : 15:30:38 Those ai suggestions are not options. Any other thoughts? This is causing some issues with shipping items due to the addresses being incorrect.
dbdave ECT Moderator USA 10792 Posts	Posted - 08/31/2026 : 16:55:13 It could be the customer just used copy/paste from another document. We have been fighting this for years and once in a blue moon it still pops up. When we see the issue, we just edit the customers order with the proper character. Thanks, David
steven vaccaro Ecommerce Template Guru USA 1174 Posts	Posted - 09/01/2026 : 04:47:15 Its not just the customers area, which is happening often now. There are errors all over the website text/descriptions. This all started after the move to a new server.
Vince Administrator 43508 Posts	Posted - 09/02/2026 : 04:31:15 Hi Steven If you go to the ECT Admin -> Database Utility page you can set the database collation there. Have you tried that? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
	« Topic »