Bugzilla – Full Text Bug Listing
| Summary: | default encoding should be UTF-8 | ||
|---|---|---|---|
| Product: | Community | Reporter: | Masayuki Fuse <fuse> |
| Component: | Bugzilla | Assignee: | Eclipse Webmaster <webmaster> |
| Status: | CLOSED FIXED | QA Contact: | |
| Severity: | minor | ||
| Priority: | P3 | CC: | antoine, d_a_carver, Ed.Merks, hceylan, nboldt, remy.suen |
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
| Whiteboard: | |||
| Bug Depends on: | 309105, 333434 | ||
| Bug Blocks: | 275102, 308815 | ||
|
Description
Masayuki Fuse
I'm not sure what I can do to fix this. It works fine with Firefox, can you try that? I confirmed that the page was displayed in FireFox but the DBCS was garbled. It's not a vaild XML file. I now understand why this happened. This bugzilla web page default encoding is Latin-1. When non Latin-1 character is entered, that will be garbled on web and xml file. I'd like to ask to change the default web encoding to UTF-8. According to the Bugzilla docs I need to run a conversion script on the bugzilla databases before this can happen. I'll see what that involves in the hopes of getting this done for Bugzilla 3.2. *** Bug 248500 has been marked as a duplicate of this bug. *** *** Bug 248706 has been marked as a duplicate of this bug. *** I'll need to apply this patch: https://bugzilla.mozilla.org/show_bug.cgi?id=508181 I'll recode the databases to UTF-8 this weekend. *** Bug 325061 has been marked as a duplicate of this bug. *** I'll really really try to do this when I upgrade to Bugzilla 3.6 I'll attempt the recode on the sandbox database. I installed the Encode::Detect stuff on one of the Bugzilla servers (what a pain!) and it seems like the recode has succeeded on the test instance. However, checksetup.pl is telling me this: We are about to convert your table storage format to UTF8. This allows Bugzilla to correctly store and sort international characters. if you have any non-UTF-8 data in your database, it ***WILL BE DELETED*** by this process. So, before you continue with checksetup.pl, if you have any non-UTF-8 data (or even if you're not sure) you should press Ctrl-C now to interrupt checksetup.pl, and run contrib/recode.pl to make all the data in your database into UTF-8. You should also back up your database before continuing. This will affect every single table in the database, even non-Bugzilla tables. I'm inquiring to the Bugzilla folks about this. This does not inspire me. "This will affect every single table in the database, even non-Bugzilla tables" Ok, after re-reading this a few dozen times and examining the source to Mysql.pm I think I've interpreted this wrong, and I'm good to go. Encoding is now set to UTF-8. I'll close this as fixed; please reopen if you see something wrong. Verified the fixed. Closing. Thanks |