http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15290 Bug ID: 15290 Summary: SQL reports encoding problem Change sponsored?: --- Product: Koha Version: 3.20 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: gmcharlt@gmail.com Reporter: vfernandes@keep.pt QA Contact: testopia@bugs.koha-community.org The problem appears when running a SQL report or exporting a SQL report. The column header are in incorrect encoding. Test plan: 1 - Add a new SQL report using the following SQL for example: SELECT borrowers.cardnumber 'Número cartão', CONCAT (borrowers.firstname, ' ' , borrowers.surname) Nome, categories.description Grupo, borrowers.branchcode Biblioteca,borrowers.dateenrolled 'Data de inscrição', borrowers.dateexpiry 'Data limite' FROM borrowers INNER JOIN categories ON borrowers.categorycode = categories.categorycode ORDER BY borrowers.cardnumber ASC 2 - Run the report 3 - The column headers are incorrect. 4 - Export the report to CSV. 5 - The column headers on the file are incorrect. -- You are receiving this mail because: You are watching all bug changes.