RE: Using multi-byte characters

[Shuichi Tamagawa]

Hi,

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.

Thanks.

--
Shu

> -----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
> 
> 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
> > &#12354;
> > 
> > 3. The character displayed after retrieving
> > &#12354;
> > 
> > 4. HTML source after retrieving the character
> > &amp;#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