PHP5 + Mysql 5 Turkish Character Settings

[MyBBHost]

Login SSH

Write :

Code:

pico /etc/my.cnf

or

Code:

nano /etc/my.cnf

Find :

Code:

[mysqld]

Under it Add :

default-character-set=latin5
default-collation=latin5_turkish_ci

Find :

Code:

[mysql.server]

Under it Add :

user=mysql
default-character-set=latin5

Find :

Code:

[mysql]

Under it Add :

default-character-set=latin5

Ctrl+X Save my.cnf

Please Restart Apache Server

[dared]

Login SSH
Write:

Code:

pico /etc/my.cnf

or

Code:

nano /etc/my.cnf

Find:

Code:

[mysqld]

Add after:
default-character-set=latin1
default-collation=latin1_turkish_ci
Find :

Code:

[mysql.server]

Add after:
user=mysql
default-character-set=latin1
Find :

Code:

[mysql]

Add after:
default-character-set=latin1
Ctrl+X Save my.cnf
Please Restart Apache Server


i think it will also work with thisway too. B-couse latin1 supports turkish special chars too...

by da way thx for info.

regards