[Koha-bugs] [Bug 4512] Encoding issue in downloaded data of guided reports

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4512

M. de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID
         AssignedTo|gmcharlt at gmail.com          |m.de.rooy at rijksmuseum.nl

--- Comment #2 from M. de Rooy <m.de.rooy at rijksmuseum.nl> 2010-11-04 13:26:52 UTC ---
(In reply to comment #1)
> In a sample report I'm running that includes patron names that contain Chinese
> characters, the output to CSV format is fine - with, or without, your patch. 
> Could you provide an example of mangled output from your database that you
> patch fixes for you?

In Koha without patch, I was checking the CSV file with Excel [2007]. The
diacritics are displayed incorrectly ('mangled output'). It appears that Excel
2007 still assumes csv files to be in Ascii; so this display problem is for
Microsoft.. If you use the Text Import wizard, and choose UTF-8, the diacritics
are displayed correctly.

But if you install the patch, the file seems to be handled correctly by Excel
right away (AT FIRST GLANCE). You can just open the file and it displays
correctly; you do need to start text import wizard and select UTF8. But when I
binary-compared the files generated with and without the patch, I discovered
that my patch resulted in a ASCII file and not UTF8. Since all diacritics were
from the Latin1 set, they were displayed correctly. But the export file is in
the wrong format.

Conclusion: Discard the patch. I am closing this bug.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.