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.
| Author |
Topic |
|
shery
Starting Member
5 Posts |
 Posted - 2011-10-24 : 11:32:08
|
| 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 RomanjiThanks in advanced! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-24 : 11:36:58
|
| whats collation used for column? does it support japanese chinese characters?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Japanese sorting In SQL