When searching against Chinese/Japanese names, sometimes people would like to enter their "phonetic values" of the "written names" in the search criteria, instead of the real written name.
I can immediately think of 2 ways to implement this, 1) is to have corresponding phonetic columns for each attribute, for example, givenname_phonetic, sn_phonetic and construct the search query accordingly. 2) is to use multi-value of givenname and sn. But this really increase the burden on the client side because now the client need to have a way to distinguish whether the value is a "written name" or a "phonetic value". Can anybody think of a better way or is there already a standard way of dealing with this? thanks, -joe
