AgileTrack
Put your development on the AgileTrack

Project description doesn't show accentuated characters correctly

Hello,
I have Agiletrack 1.1.4 server installed on windows server 2003.
I'm using MySQL server 5.0.4.5 for the database
My agiletrack client 1.1.4 is running on a windows xp service pack3 machine and is connecting to the Agiletrack server using JSON-RPC Direct.

When I try to use accentuated characters in the description field while creating a project and save the project, the accentuated characters are replaced by a square character like this—> �
Characters like éàç ect. are not saved as accentuated character in the database but as �.
On the other hand if I insert the accentuated character directly in the database (Using sqlyog) the characters will display correctly in the AgileTrack description filed until I modify the description again and resave it. Then they revert back to � in the database.

I tried modifying the encoding of the table field from utf8 to Latin and other encoding but this had no effect.

From what I can understand its like there is some kind of conversion done by agiletrack before the value is saved to the database.

Any help would be greatly appreciated.

Thanks

—Posted by Alain Laniel on Jun 10, 2008


	Forum AgileTrack Server


	Reply

I'm looking into this problem right now. There was a known problem with the JSON-RPC interface a while back. I'm working on reproducing the error right now. Right now, the JSON-RPC interface decodes the text as UTF-8. So, the server is probably loading the string as UTF-8, but the client must not be sending it in the format when saving.

Hopefully I'll be able to reproduce the problem, and then I'll get you a patch to try out the fix.

—Posted by Adam Lane on Jun 11, 2008 at 2:43:56 PM

I changed the connection type in my client to JSON-RPC Over HTTP and now it's working the accentuated characters are sent correctly to the database.
Like you said this seems to be related to JSON-RPC Direct type of connection.

—Posted by Alain Laniel on Jun 11, 2008 at 2:54:50 PM

Well, I believe I was able to reproduce the problem and fix it. You'll need to download a new agiletrack-jsonrpc.jar and replace the old one in the agiletrack/lib directory.

Let me know if it doesn't work.

—Posted by Adam Lane on Jun 11, 2008 at 4:30:53 PM