special characters in service description

Hi Gabe,

I’ll be happy to help.

Please, open your WordPress database structure using phpMyAdmin and let me know which encoding is set for table wbk_services.

Hi,

thanks for your quick response. I think I might have found the culprit (https://ibb.co/PxP5BV3) (latin1_swedish_ci, currently.)

• What collation should it be? (“something”_hungarian_ci)?
• if I change that, do I have to check the “Change all column…” setting?

Thank you very much
Gabe

• This reply was modified 1 year ago by geekayhu.

Hi Gabe,

Please, change the collation to utf_general_ci. After that try to save the service again.

If the problem persists, please let me know.

Hi there,

thanks for the advice, since there is no “simple” utf, I picked utf8mb4_general_ci and it works so far.

Thanks again, have a great day!
Kind regards
Gabe

Glad I could help:)

Have a great day!

Hi there,

I did not open another ticket because my current issue is almost the same but with the email messages (characters with accents not showing, it should be “? -> ?”: https://ibb.co/g31Hh1P).

Can you please tell me which collation should I also change, because I tried the one with the wbk_email_tempalates (https://ibb.co/nPxzXXs) but it does not seem the one I should change(?) (I’m not sure).

Thank you in advance,
Kind regards, Gabe

Hi,

It looks like your collation is correct and doesn’t require changes.

Could you please copy / paste here the template you are using so I can try on my side?

Hi,

Thanks for your quick response. This is the copy/paste message we’d use for booking modification in the email templates.

________________________________

Kedves #customer_name,

Id?pontfoglalásod a k?vetkez?re módosult:

#service_name
#appointment_day ? #appointment_time
#total_amount

Szeretettel várunk szalonunkban.
Amennyiben biztosan nem tudsz megjelenni, az id?pont felszabadításához/t?rléséhez (min. 48h-val korábban), kérjük kattints az alábbi linkre:

#cancel_link

_________________________________

the problem is with the Hungarian character “?” in this particular case (but any with ?, ?…) and it changes back to “?” as you can see. I made a quick screencast to show that after saving it changed back for me.

The email sent about modification to the customer is just fine, only those characters are not OK.

Thank you!
Gabe

Hi guys,

Do you have any follow-up about this issue? My client has just received a booking, and the character “?” is a “?” mark in the email (https://ibb.co/bQyPF9b)

Is there, maybe, some other places in the database that I should change the encoding?

Thanks!
Kind regards, Gabe

Hi,

Sorry, for some reason we missed this topic.

Could you please, open hosting panel – phpMyAdmin – Structure and let me know encoding of the table ‘wbk_email_templates’?

Hi there,

It’s ok… ?? this topic was long ??

Anyway, the encoding is “utf8mb4_general_ci” (https://ibb.co/4WFvgvh)

Regards, Gabe

Could you please check in the content (rows) of the ‘wbk_email_templates’ table if template is stored with correct characters or not?

2 things:

• the last email I shared came from a client, that error is in the text that the client wrote, not part of the template (it’s coming from the booking form message field);
• as for the template: I cannot save the text in the row (content), I changed the “?” to “?”, and set save/go in the phpmyadmin, but it changed back to “?” (or maybe I’m a bit tired to think :))
• screencast: https://youtu.be/d9mnYVdUPcA

So, both the template, and the booking form message field (if a client leaves a message while booking) have errors with special characters (in this case “?” / “?”)

Gabe

Hi Gabe,

Could you please clarify which encoding is set for other tables in your WP database? For example for wp_posts table?

Hi,

Checking the posts and some other tables, it’s: utf8mb4_unicode_520_ci (https://ibb.co/2qpGnRn)

(and previously I tried to set this (…520_ci) to the wbk_templates, but it does not help, either)

Gabe