Bulgarian not supported at all?

Permalink 1 user found helpful
Hi guys, I tried to use Bulgarian in menus and content, however it all comes in question marks (?????). I changed encoding, but it did not work. I checked in the forum here, and there's quite some info for localizing the system and displaying menus in other languages, however, I could not find a problem similar to mine. Could you advise?

 
Brainakazariua replied on at Permalink Reply
Brainakazariua
Your database was not created to support UTF8. Assuming that the name of your database is "concrete", it should have been created with this command.

mysql> create database concrete default character set utf8 default collate utf8_unicode_ci;

to change it at this point run this command on the database:
ALTER DATABASE `concrete` DEFAULT CHARACTER utf8 COLLATE utf8_unicode_ci;


In php.ini, you should set the following variables.

default_charset = "UTF-8"
mbstring.internal_encoding = UTF-8

If you own the server or have full control over mysql, you can add the following lines to /etc/mysql/my.cnf under the appropriate sections to force all connections to all databases to be UTF8.

[client]
default-character-set=utf8

[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci; SET NAMES utf8;'
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

[mysqldump]
default-character-set=utf8

[mysql]
default-character-set=utf8
trialtur replied on at Permalink Reply
Thank you for your response! However, this was a trial account created automatically. Isn't there anything I can do like "in the cloud" of my online account?
Brainakazariua replied on at Permalink Reply
Brainakazariua
I doubt it, I don't think you have acces to the database on a trial account, I suggest you move past trial when going as far as language support and try it on your own test enviroment at your host.

I do believe that the databases that come with a trial account are configured correctly.
trialtur replied on at Permalink Reply
That's what I thought, but wanted to check if I haven't missed anything. Basically, I wanted to make sure that I can work with Bulgarian before going forward, but I guess the fact that there's this type of Unicode support answers the question and I have to move to the next step with my trial account.

Thanks for your help!
Brainakazariua replied on at Permalink Best Answer Reply
Brainakazariua
I believe that is should work with any language as long as the database is set correctly.

You might ask frz about the language support on trial accounts, he can give you much better answers on those then we users can.