Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Japanese sorting In SQL

Author  Topic 

shery
Starting Member

5 Posts

Posted - 2011-10-24 : 11:34:18
I have SQL database table with journals in Japanese/Chinese and I want to build an A-Z list from these journals, and also to search for them.
But, I'm facing with some SQL problems:

1) How to index CJK (Chinese Japanese Korean)?
2) How to sort within CJK?
3) How can I create A-Z list? (The letters are in Hiragana, Katakana & Kanji)
4) How to create a segmentation algorithm?
5) How can I search with CJK?
The major problem is How to do so when I click on journal starting with Hiragana it will give me journals in starting with kanji and also Romanji

Thanks in advanced!

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-10-24 : 11:36:35
Dupe:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=167087
Go to Top of Page
   

- Advertisement -