Thanks for your reply.
Here is the verson information.
MySQL : 4.1.9
PHP : 4.3.10
I'll get back to you after the test you suggested.
> -----Original Message-----
> From: Bryan Alsdorf [mailto:bryan@stripped]
> Sent: Wednesday, February 23, 2005 12:45 PM
> To: Shuichi Tamagawa
> Cc: eventum-devel@stripped
> Subject: Re: Using multi-byte characters
> 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
> 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.
> 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