6 messages in com.mysql.lists.eventum-develRe: Using multi-byte characters| From | Sent On | Attachments |
|---|---|---|
| Shuichi Tamagawa | 13 Feb 2005 22:10 | |
| Bryan Alsdorf | 23 Feb 2005 12:44 | |
| Shuichi Tamagawa | 28 Feb 2005 01:57 | |
| Shuichi Tamagawa | 28 Feb 2005 03:10 | |
| Bryan Alsdorf | 07 Mar 2005 01:24 | |
| Shuichi Tamagawa | 08 Mar 2005 21:37 |
| Subject: | Re: Using multi-byte characters |
|---|---|
| From: | Bryan Alsdorf (bry...@mysql.com) |
| Date: | 02/23/2005 12:44:35 PM |
| List: | com.mysql.lists.eventum-devel |
Hi,
I am not sure how much help I will be able to since I have been unable to generate (JAPANESE HIRAGANA LETTER A) for testing. I will do my best to help you investigate this on your system though.
What version of PHP do you have? What version of MySQL do you have?
Here are several things you should try see where the data is being converted.
1. Print out the data as soon as it is submitted. You can do this by adding var_dump($_POST); to new.php.
2. Print out the data immediately before it is inserted. You will need to edit include/class.issue.php, the insert() method, about line 1665.
Let me know if the character is still intact at both of those places.
Regards, /bryan
Shuichi Tamagawa wrote:
Hi
I'd like to use multi-byte characters for the data of issue records.
It seems that, however, Eventum converts the multi-byte characters to Numeric Character Reference to Unicode when the data is submitted and store to the database as a 'string' of NCR.
As a result, the multi-byte characters are not displayed correctly.
<Example> 1. The character submitted from Eventum screen(JAPANESE HIRAGANA LETTER A). あ
2. The character in the database あ
3. The character displayed after retrieving あ
4. HTML source after retrieving the character &#12354;
How can I store the multi-byte characters to the database as is without converting to NCR?
-- Shu
-- Bryan Alsdorf, Software Engineer MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification