Solution for Turkish Character Issue in MySQL Server
If you encounter Turkish character issues on your new server purchased from abroad (such as LayerTech or EV1, where the default language is English), you can easily resolve this problem by following the steps below:
The first step is to connect to your server via SSH and log in as root. You can start by using the free and widely available PuTTY program.
Once connected to your server by entering the root username and password provided by your hosting company,
type the following command into the command line:
Code:
If you encounter Turkish character issues on your new server purchased from abroad (such as LayerTech or EV1, where the default language is English), you can easily resolve this problem by following the steps below:
The first step is to connect to your server via SSH and log in as root. You can start by using the free and widely available PuTTY program.
Once connected to your server by entering the root username and password provided by your hosting company,
type the following command into the command line:
Code:
Kod:
pico /etc/my.cnf
Insert the following codes into an empty space in the my.cnf file.
Kod:
default-character-set=latin5
default-collation=latin5_turkish_ci
init_connect='SET NAMES latin5'
Then press Ctrl+X. It will ask you if you want to save the changes. Type 'y' or 'yes' and then press the Enter key.
Afterwards, type the following into the command line:
Code:
Afterwards, type the following into the command line:
Code:
Kod:
/scripts/restartsrv mysql
Now Turkish characters are displayed without any issues on your new server.
Additional Note
Additional Note
Kod:
default-character-set=latin5
default-collation=latin5_turkish_ci
These two should be in my.cnf. Press Ctrl+W to search for what's left of the equal sign. If found, replace it.
default-character-set=latin5
default-collation=latin5_swedish_ci
Topic Owner : @CorsaiR
default-character-set=latin5
default-collation=latin5_swedish_ci
Topic Owner : @CorsaiR
Mysql Türkçe Karekter sorunu server için çözüm yolu.
Mysql Türkçe Karekter sorunu server için çözüm yolu. Yurt dışından aldığınız yeni serverınızda (layertech, ev1 den aldığınız makinanızda default dil ingilizcedir) eger sizde türkçe karekter sorunu yaşıyorsanız aşağıdaki adımları takip edererek bu sorunu kolayca çözebilirsiniz: ilk adım...
www.turkhackteam.org