ezdb_mysql.class.php for Russian

phpVMS Legacy Support (v2/v5)
1

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!

2

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 …

3

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 “ш”

4

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

5

Nabeel,

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

6

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

7

Nabeel

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

8

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

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

9

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’);

10

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

11

It’s been added for 2.1

12

It’s been added for 2.1

Thanks