[tlug] [Fwd: Search MySQL for Japanese Names]

[Edward Middleton <emiddleton@example.com>]

--- Begin Message ---

• Date: Mon, 19 Oct 2009 14:31:21 +0900
• From: Dave M G <dave@example.com>
• Subject: Search MySQL for Japanese Names
• User-agent: Thunderbird 2.0.0.23 (X11/20090817)

TLUG,

I've been tasked with building a MySQL database that will store the
names of people in Japanese kanji. Those names need to be searched
alphabetically from a web interface.

By "alphabetically", I mean in order of the hiragana... あいうえお、かき
くけこ..., and so on.

Since kanji can have multiple readings, will I need to store a separate,
katakana version of the name in order to search for it "alphabetically"?

Will that katakana need to be half width, or does it matter?

Or can I get an ascending order of names with just the kanji?

Or should I say screw it and get the users to put in a romaji version of
their name?

Any advice much appreciated.


-- 
Dave M G
http://tlug.jp/mediawiki/index.php?title=User:Dave_M_G

--- End Message ---