这是indexloc提供的服务,不要输入任何密码
Skip to content

Database connection not using utf8 charset #92

@Pontusfroding

Description

@Pontusfroding

I live in Sweden and we have some strange names with å ä ö in them ;)

There is some problem with the encoding which I discovered when I tried to edit and add some people. I cant add and edit people because it just gives me a blank page, so I was gonna do it direct in the database. Then I saw that the encoding in the database was wrong. ö looks like ö in the database and if I change them there to ö then it will be wrong on the web.

After changing line 61 in /php/classes/db/db.inc.php it works but I will have to change all the names since they were saved wrong before. Maybe it is possible to make the changes automatic in some way but that's above my knowledge for the moment.

The changes on line 61

  •    static::$connection=new PDO($dsn,$dbuser,$dbpass);
    
  •    static::$connection=new PDO($dsn,$dbuser,$dbpass,array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
    

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions