Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] Foreign Language Character Problem

9 years 3 months ago - 9 years 3 months ago #267825 by satrancokulu
[SOLVED] Foreign Language Character Problem was created by satrancokulu
Hi,

Using foreign language character is like "?" I installed language files. It causes problem when creating fields etc..

I added the screenshot.

Regards

Selim Gurcan
Attachments:
Last edit: 9 years 3 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48474
  • Thanks: 8281
  • Karma: 1443
9 years 3 months ago - 9 years 3 months ago #267861 by krileon
Replied by krileon on topic Foreign Language Character Problem
Is that the translated title from a language string or the title stored directly in the database? If it's directly stored in database then check your database tables and columns to ensure they're properly configured for UTF8. Specifically ensure _comprofiler_fields and its columns have collation set to utf8_general_ci.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Last edit: 9 years 3 months ago by krileon.

Please Log in or Create an account to join the conversation.

9 years 3 months ago #267872 by satrancokulu
Replied by satrancokulu on topic Foreign Language Character Problem
Thank you for that answer. I thought that automatically everything would be smooth :( I normally dont have such problems with other extensions.

I will be glad if you guide me more.

This is the screenshot. How should i change to utf8_general_ci. I dont want to spoil things.

Regards

Selim Gurcan
Attachments:

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48474
  • Thanks: 8281
  • Karma: 1443
9 years 3 months ago #267876 by krileon
Replied by krileon on topic Foreign Language Character Problem
Looks like the collation is wrong. This can happen depending on the default collation set for your database as CB doesn't set one. Default collation for your database is probably set to latin1_swedish_ci, but CB and Joomla are all UTF8.

To fix click the Operations tab at the top of the page while viewing the _comprofiler_fields table. Now change "Collation" to "utf8_general_ci" and click "Go". If the column collations are still latin1_swedish_ci you'll need to click "Change" while viewing the table Structure to change them individually.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: satrancokulu

Please Log in or Create an account to join the conversation.

9 years 3 months ago - 9 years 3 months ago #267888 by satrancokulu
Replied by satrancokulu on topic Foreign Language Character Problem
Excellent solution. Thank you! As you said first method didnt work but "Change" button solved the problem. Thank you for foreseeing the possible problem.

Selim Gurcan
Last edit: 9 years 3 months ago by satrancokulu.
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum