Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : about charset

[kteo]

hello there i recently bought an new server ...the problem is i have problems with charsets in all the php-mysql sites whick i setup..i am from greece and i want all to have as default the greek lang...what exactly i must change from mysql or apache to have all working fine with greek charset ISO-8859-7

Before your answers i must tell you that
2))i have change in php.ini as default language to the greek ISO-8859-7
2)also in phpmyadmin mysql connection collation is set it in UTF_8 bin
BUT THE Problem stills remains

[PremiumHost]

Log in SSH and try this command
mysqld --character-set-server=ISO-8859-7
Change in php.ini will not help because you want to configure mysql default charset.

[MaximSupport]

Dear kteo,

Originally Posted by PremiumHost

Log in SSH and try this command
mysqld --character-set-server=ISO-8859-7
Change in php.ini will not help because you want to configure mysql default charset.

You can also do this by editing your MySQL Configuration File.

vi /etc/my.cnf

[mysqld]
character_set_server = ISO-8859-7
default-character-set = ISO-8859-7
.
.
.

Edit your php.ini

Note: my path for php.ini is /usr/local/lib

vi /usr/local/lib/php.ini

mbstring.internal_encoding=ISO-8859-7
mbstring.http_input=auto
mbstring.detect_order=UCS-4, UCS-4BE, UCS-4LE, UCS-2, UCS-2BE, UCS-2LE, UTF-32, UTF-32BE, UTF-32LE, UCS-2LE, UTF-16, UTF-16BE, UTF-16LE, UTF-8, UTF-7, ASCII,ISO-8859-2, ISO-8859-1, ISO-8859-3, ISO-8859-4, ISO-8859-5, ISO-8859-6, ISO-8859-7, ISO-8859-8, ISO-8859-9, ISO-8859-10, ISO-8859-13, ISO-8859-14, ISO-8859-15, BASE64, EUC-JP, SJIS, eucJP-win, SJIS-win, ISO-2022-JP, JIS
mbstring.substitute_character=none

Best Regards.

[david510]

The charset related to the description "ISO 8859-7 Greek" is greek. So the charset name is greek. You need to specify the value as given below.

[mysqld]
character_set_server = greek
default-character-set = greek

mbstring.internal_encoding=greek