Turkish characters appear as question marks

[pars]

Hello forum,

On cpanel turkish characters appear as question marks. Does cpanel support turkish chacarters? Thanks!

 

[cPRex]

Hey there!

When certain characters aren't being displayed properly, this is often an issue with the character set of the database the site is using.

You may want to see if your database is using the UTF8 character set using the details here:

How to change the collation or character set for your database in cPanel

Introduction The default character set or collation for MySQL is set to latin1 for database, What is the default character set for MySQL on cPanel & WHM servers? Sometimes you will need to chan...

support.cpanel.net

If you make that switch, and that does indeed resolve the issue, you can apply that change permanently with these steps:

How Do I Change The Default Character Set in MySQL/MariaDB to utf8?

Introduction How do I change the default Character set within MySQL/MariaDB to utf8? Procedure In order to set change the default character set within MySQL/MariaDB follow the steps below: ...

support.cpanel.net

Let me know if that helps!

 

[pars]

Thanks a lot for your reply.


>Once loaded, select the database you want to modify from the left side.

The problem is that I don't know which database to modify. I have 10 of them.

I would understand if you cannot help with that.

Hey there!

When certain characters aren't being displayed properly, this is often an issue with the character set of the database the site is using.

You may want to see if your database is using the UTF8 character set using the details here:

How to change the collation or character set for your database in cPanel

Introduction The default character set or collation for MySQL is set to latin1 for database, What is the default character set for MySQL on cPanel & WHM servers? Sometimes you will need to chan...

support.cpanel.net

If you make that switch, and that does indeed resolve the issue, you can apply that change permanently with these steps:

How Do I Change The Default Character Set in MySQL/MariaDB to utf8?

Introduction How do I change the default Character set within MySQL/MariaDB to utf8? Procedure In order to set change the default character set within MySQL/MariaDB follow the steps below: ...

support.cpanel.net

Let me know if that helps!

 

[cPRex]

The database you would need to choose would depend on the site's configuration. For example, if this is a Wordpress site, you would open the wp-config.php file located in /home/username/public_html to see what the configuration details there are. I would expect each site to have a similar configuration file that lists the database connection details.

 

[pars]

Thanks a lot.

In wp-config.php file I see:

/** Database Charset to use in creating database tables. */
define( 'DB_CHARSET', 'utf8' );

This would support turkish characters no? It doesn't apparently.

 

[cPRex]

That line would indicate that any new databases would be created with UTF-8. However, it wouldn't apply that value to existing databases. You'd want to check your Wordpress database using the steps I outlined above to ensure that is in place on the active database.

 

[pars]

Thanks for your help. For all databases I have utf8_unicode_ci. This supports turkish characters no?

See the screenshot:

Screen-Shot-2020-11-24-at-17-39-57

Image Screen-Shot-2020-11-24-at-17-39-57 hosted in ImgBB

ibb.co

Thank you very much.

 

[pars]

I tried to change it to utf8_turkish_ci it didn't change anything.

I greatly appreciate your support.

 

[cPRex]

That does look correct, so I would expect that to work. It may be best to put in a ticket so we can access the server directly and see what the issue is. If you do that, please post the ticket number here so I can follow along, and then I can update this thread with the resolution.