Loading Profile...
Twitter,
Facebook, or email.
Greetings,
I installed SW Pro 4.5.1 fresh with a MySQL database.
When I enter Japanese text into a task in the demo product, e.g. "日本語テスト" through a desktop, it is accepted by the client. However, when I re-open the same task, the text that I entered is displayed as question marks, e.g. "??????" (one ? for each letter).
This is an issue only with MySQL version of SW, with the desktop client. Web client is okay (in both MySQL and Hypersonic versions); Hypersonic version is also okay (even with the desktop client).
I am running the desktop client on:
- Windows XP SP3
- Firefox 3.6.13
- JRE 6 (build 1.6.0_23-b05)
- Non-Unicode system locale set to Korean.
The same symptom has been observed on my coworker's laptop:
- Windows Vista SP2
- Firefox 3.6.13
- JRE 6 (build 1.6.0_23-b05)
- Non-Unicode system locale set to Japanese.
/scratches head
Eugene
P.S. This is currently preventing us from migrating our database from Hypersonic to MySQL; I would like a solution ASAP.
I’m
puzzled
Foreign text displayed as "??????" in desktop client with MySQL
Official
Response
-
Caleb's solution above works, but it is not elegant in that you're setting UTF-8 on the MySQL server level, affecting all databases on that server. A more ScrumWorks specific solution follows:
- Edit /server/scrumworks/scrumworks-mysql-ds.xml
- Shut down ScrumWorks server
- Locate the line with the following tag:
<connection-url> - Add this query string:
?useUnicode=yes&characterEncoding=UTF-8 - It should look something like:
<connection-url>jdbc:mysql://localhost/scrumworks?useUnicode=yes&cha
racterEncoding=UTF-8</connection-url> - Start ScrumWorks server
EMPLOYEE
-
EMPLOYEE
1Hi Eugene,
Should just have to set up the MySQL database you are using as UTF-8. I dug around a bit in some old cases and one customer said they resolved it by adding the following option to the options file:
character-set-server=utf8
I believe the MySQL documentation covers that here: http://dev.mysql.com/doc/refman/5.0/e...Comment -
-
I’m
all YAAAAAAY!
I added character_set_server=utf8 (note underscores instead of dashes :-p) to the [mysqld] section of my.cnf, restarted the server, and it now works correctly.
IMHO this should be added to your MySQL Database Guide.
Thank you for the prompt response!-
Right you are, I'll pass that up the chain to get updated :)
-
-
-
-
-
Caleb's solution above works, but it is not elegant in that you're setting UTF-8 on the MySQL server level, affecting all databases on that server. A more ScrumWorks specific solution follows:
- Edit /server/scrumworks/scrumworks-mysql-ds.xml
- Shut down ScrumWorks server
- Locate the line with the following tag:
<connection-url> - Add this query string:
?useUnicode=yes&characterEncoding=UTF-8 - It should look something like:
<connection-url>jdbc:mysql://localhost/scrumworks?useUnicode=yes&cha
racterEncoding=UTF-8</connection-url> - Start ScrumWorks server
-
The website ruined the actual connection string. The & should be "& amp;" (no spaces or quotes)
-
-
-
