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

[Janos Gyerik <janos.gyerik@example.com>]

Hi,

Since there can be multiple readings of kanji, typical user interfaces
ask for furigana (= katakana) input as well, so your DB will have a
separate column for katakana anyway, so I guess your problem will be
solved "naturally". Why not?

As far as I can recall, the ascending order just by kanji is "funny".
So probably you will want to order by the katakana column. I would
load some dummy data and run a couple of queries to test.

And, use full-width katakana (zenkaku), never ever ever ever half
width! (If you look at Japanese user-interfaces, they use full-width
most of the time if not always, so this approach is quite normal.)

Cheers,
Janos


On Mon, Oct 19, 2009 at 2:48 PM, Edward Middleton <emiddleton@example.com> wrote:
>
>
> 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
>
> --
> To unsubscribe from this mailing list,
> please see the instructions at http://lists.tlug.jp/list.html
>
> The TLUG mailing list is hosted by the award-winning Internet provider
> ASAHI Net.
> Visit ASAHI Net's English-language Web page: http://asahi-net.jp/en/
>