Re: Using multi-byte characters

[Bryan Alsdorf]

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