[phoecxan]

Hi

How can I change MySQL Database Character Encodinig ?I want to change the " latin1_general_ci " to " UTF-8 ". Below " figure_1 " .If you know and help for this problem.Can you explain this problem step by step.
Thank for view my post.
Figure_1:

[marksfish]

Looking for an answer to this myself. I thought it would be as simple as going to the operations tab and changing the encoding in there. Unfortunately it wasn't that easy

[Bad Karma[CORE]]

pull a backup, modify the textfile and change every instance of the collation you have to the collation you want. drop all the tables in the database, change the collation of the database itself and then import the modified backup. As simple as that

[marksfish]

A reply I got from another forum:

You can change the collation from phpmyadmin for the tables . About character set , you need to search for your language file within your joomla installation and edit the character set .

For example : Search for "charset=iso-8859-1" and replace with "charset=iso-UTF-8" as given below :

Code:
DEFINE('_ISO','charset=iso-8859-1');with

Code:
DEFINE('_ISO','charset=UTF-8');and save changes to the file.

Mark

[vahur]

Originally Posted by Bad Karma[CORE]

pull a backup, modify the textfile and change every instance of the collation you have to the collation you want. drop all the tables in the database, change the collation of the database itself and then import the modified backup. As simple as that

it`s interesting. Thanks to 'Bad Karma[CORE]'

my question is:
i tryng to made my site multilingual and one lang. is russian.
HTML code:
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta name="Content-Language" content="Russian">
database:
cp1251_general_ci

on my laptop with apache server works all good, when i want to see this page on web is there only "????".
http://vahur.comze.com/index.php?lk=1&lng=rus

whats wrong?

[vahur]

Hi !

I find the answer. After database connection must be writen:

mysql_query("SET NAMES cp1251");
mysql_query("SET CHARACTER SET cp1251");

This is a problem with MySQL 4.1 and higher.