Gossamer Forum
Home : Products : Others : MySQLMan :

Unicode display problem

Quote Reply
Unicode display problem
Hi,

I'm currently trying out MySQLMan. So far it's very nifty. I use Unicode (Vietnamese) in my database. In Browse mode, all character appears all right. However, in edit/insert mode, the character doesnot come out right. (See attached images)

I think it's a font setting problem with the input box of edit/insert mode.

I appreciate any pointer on this.

Nhan Tran
Quote Reply
Re: [thnhan] Unicode display problem In reply to
It's probably something to do with encoding format. Can you possibly send me a copy of that page? Basically do a save of the HTML so I can see both the proper encoding and what happens in mysqlman's editboxes to corrupt the text.
Quote Reply
Re: [Aki] Unicode display problem In reply to
In Reply To:
It's probably something to do with encoding format. Can you possibly send me a copy of that page? Basically do a save of the HTML so I can see both the proper encoding and what happens in mysqlman's editboxes to corrupt the text.


Enclosed are the 2 .html files: good.html and bad.html

Nhan Tran
Quote Reply
Re: [thnhan] Unicode display problem In reply to
The problem is with the encoding format. Can you try this for me?

Edit the file CGI.pm found in the GT directory.

Around line 506 you'll find the html_escape function. Can you remove the following line?

Code:
$$toencode =~ s/"/"/g;

There will be another instance that looks much like that comment that out as well. It may have unwanted consequences on other parts of the program so if that doesn't work, please let me know.
Quote Reply
Re: [Aki] Unicode display problem In reply to
In Reply To:
The problem is with the encoding format. Can you try this for me?

Edit the file CGI.pm found in the GT directory.

Around line 506 you'll find the html_escape function. Can you remove the following line?

Code:
$$toencode =~ s/"/"/g;


I tried it but the problem remains the same.

Nhan Tran
Quote Reply
Re: [thnhan] Unicode display problem In reply to
There's also another line that looks like that, remove that one too.
Quote Reply
Re: [Aki] Unicode display problem In reply to
I have removed both "toencode" line. Problem still remains.

I go ahead remove both "todecode" line too. Still the same.

Nhan
Quote Reply
Re: [thnhan] Unicode display problem In reply to
Ok, this is going to require more work than I thought. Could you provide me with an sql dump of the table you're using? Just one record with the unicode escapes is enough.

Sorry about the trouble.
Quote Reply
Re: [Aki] Unicode display problem In reply to
Here it is. Thanks for your help.

Nhan Tran