Japanese Characters

[Siann Beck]

I have to confess I've always been a bit baffled by character encodings, so I'm only assuming it's a database issue, but I have correct data coming from one field and not another, so that's the basis of my assumption. Table definition:

[pre]ListingID    int(11)      DEFAULT NULL,

Language      char(2)      COLLATE utf8_unicode_ci DEFAULT NULL,

Title        varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

Description  text        COLLATE utf8_unicode_ci,

Search        text        COLLATE utf8_unicode_ci,

UNIQUE KEY    ListingID_2  (ListingID,Language),

KEY          ListingID    (ListingID),

FULLTEXT KEY  Search      (Search)

ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci[/pre]

Server version:        5.1.36

 

When someone enters Japanese characters, the title displays properly, but the description does not. Example:

 

http://www.metaverseexchange.com/listing.php?id=8164&lc=ja

[Ken2k7]

Looks like when you print them, the & becomes & which messes up the special character display. Try replacing the & with &.

[Siann Beck]

::sigh::

 

I'm an idiot.

 

The BBCode parser was converting them.

 

*Siann Beck smacks herself in the forehead.