[#SQ-374] Projects named with non-latin characters don't show up correctly. - dashboard

squeakland

Projects named with non-latin characters don't show up correctly.

Created: 12/Sep/09 09:55 PM Updated: 28/Aug/10 02:35 PM

Component/s:

showcase

Fix Version/s:

None

Time Tracking:

Not Specified

File Attachments:

None

Image Attachments:

1. Screen shot 2009-09-14 at 10.46.38 AM.png
(21 kB)

Issue Links:

Related

This issue is related to:

SQ-284 Mail-Forum gateway messes up encoding

Description

« Hide

Projects named in Japanese shows up with question marks in their file names when visited on the site.

... for later ...

iconv --from-code=ISO-8859-1 --to-code=UTF-8 iso.txt > utf.txt

... better ...

http://confluence.atlassian.com/display/DOC/Configuring+Database+Character+Encoding

Sort Order:

[ Permalink | « Hide ]

teefal added a comment - 12/Sep/09 10:01 PM

This is a known issue with the entire website. MySQL needs to be coaxed into using UTF-8.

I researched this for about an hour last April, and will address when there's time. It's currently set to 8859-1.

[ Permalink | « Hide ]

teefal added a comment - 12/Sep/09 10:05 PM

I should also say that it's more time consuming that simply changing the settings.

Legacy content needs to be translated, and there's considerable risk for mangled stuff.

[ Permalink | « Hide ]

Yoshiki Ohshima added a comment - 12/Sep/09 10:43 PM

This issue is duplicates... with which one?

[ Permalink | « Hide ]

teefal added a comment - 12/Sep/09 10:48 PM

MU-172 (switch MySQL to UTF-8)

This is a server wide task, which is why it's in the Immuexa project.

[ Permalink | « Hide ]

Yoshiki Ohshima added a comment - 12/Sep/09 11:58 PM

Ah, a ticket in some other project. I cannot see it and I'm not sure if it makes sense to mark it as a duplicate, but that is what it is. I also suspected the client side but the client code appears ok.

[ Permalink | « Hide ]

Yoshiki Ohshima added a comment - 13/Sep/09 11:43 AM

Ah, it is reopened. Good. While some part of the issue may have been "known", we should wait until we confirm that our client code and whole thing does work with this proposed change.

[ Permalink | « Hide ]

teefal added a comment - 14/Sep/09 10:51 AM

I sent an hour on this today, and managed to get it working on my local machine (mac).

Database on my machine is a binary copy of the skylab database, and all the configuration and startup scripts are the same.

Looked at the mysql variables and they all looked the same too.

Anyway, moving on to other things. Sorry Japan, Russia, etc :)

[ Permalink | « Hide ]

teefal added a comment - 14/Sep/09 10:52 AM

And yes, dates need to be i18n, and we need a japanese version of the resource files (see "by")

We already have Portuguese.

[ Permalink | « Hide ]

teefal added a comment - 25/Oct/09 09:16 AM

Known issue.

[ Permalink | « Hide ]

teefal added a comment - 09/Nov/09 10:24 AM

it's likely a mysql thing

[ Permalink | « Hide ]

teefal added a comment - 14/Jan/10 09:31 AM

use this:

http://confluence.atlassian.com/display/DOC/Configuring+Database+Character+Encoding#ConfiguringDatabaseCharacterEncoding-UpdatingexistingdatabasetoUTF8