ezdb_mysql.class.php for Russian

[stasnosikov]

Gday!

You could add the following line

public function connect($dbuser='', $dbpassword='', $dbhost='localhost')
{
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword, true);
       mysql_query (' SET NAMES utf8 ');  //It is added
if(!$this->dbh)
       ......

in a file /core/classes/ezdb/ezdb_mysql.class.php in the next release phpvms ?

I had problems with the charset in Russian, after addition of this line of problems are not present!

[Artjom]

hi, this code is not working, pilots can't write names in Russian language (gives characters example: Артём Антипов), the download page has the same problem with Russian does not understand and the Sceudules page has the same problem with Russian ...

[stasnosikov]

hi, this code is not working, pilots can't write names in Russian language (gives characters example: Артём Антипов), the download page has the same problem with Russian does not understand and the Sceudules page has the same problem with Russian ...

hi, It works here an example http://uiii.su/index.php/pilots

It is necessary for you through the adminpanel or through phpmyadmin anew to copy all Russian words. Because without this line "mysql_query (' SET NAMES utf8 ');" the database was stored and registered in the charset cp1251, therefore there was a problem with Russian letters "И" and "ш"

[Nabeel]

I think if you set the database table to utf8, then you shouldn't need to do SET NAMES command

[Artjom]

Nabeel,

you could not solve the problem with Russian language! atoms as I had not suffered all of any problems, ask for help

[Nabeel]

I'll look into it, but that's the wrong place to put it - it'll go into codon.config.php. Thanks

[Artjom]

Nabeel

Please try, I think that all Russian and Ukrainian people you will be grateful

[Nabeel]

I've added it to the bug tracker, to look into:

http://bugs.phpvms.net/browse/VMS-253

[stasnosikov]

I've added it to the bug tracker, to look into:

http://bugs.phpvms.net/browse/VMS-253

Thanks, the matter is that on many Russian servers in Mysql global values in cp1251 are established, therefore exist this problem.

Here variables of my hosting:

http://file.qip.ru/file/125989387/d7097b60/values.html

Here tables phpvms:

http://file.qip.ru/file/125989388/47b666f1/tables.html

In this situation there is a problem with the Russian charset without a line - mysql_query('SET NAMES utf8');

[Nabeel]

Yep, I just have to make sure this won't adversely affect other hosts who do not have any other setting or are strictly western/latin table types

[Nabeel]

It's been added for 2.1

[stasnosikov]

It's been added for 2.1

Thanks