client_encoding in postgresql

[ilia_kantor]

The ticket refers to postgresql, didn't test it with sqlite.

Sometimes files have other encoding then UTF8. If that happens, timeline doesn't work, probably other trac modules.

To fix that, I added a 2 lines line to db.py

--- after ---
            cnx = PgSQL.connect('', user, password, host, path,port)
--- add this --- 
            cnx.cursor().execute('SET CLIENT_ENCODING TO \'win\';')
            cnx.commit()

--- end ---

I suggest to add client_encoding parameter to trac.ini (database setting ?)

[Christopher Lenz]

The encoding of files in the version control repository has nothing to do with encoding over the database connection… the files are not read from the DB. Please provide specifics about the actual problem you're seeing, I think you may have jumped to the wrong conclusion here.

[Christian Boos]

Since there's been no feedback since 9 months, I think we can close this.

If there's any real issue with CLIENT_ENCODING and postgres, please reopen and document precisely what's going wrong and the steps to reproduce the error.