Japanese sorting In SQL - SQL Server Forums

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

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Japanese sorting In SQL

Author

Topic

shery
Starting Member

5 Posts

Posted - 2011-08-16 : 09:03:08

Hi,

I'm Sharon, Web Developer, 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!
Sharon

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-17 : 04:14:49

whats collation you're using for the db?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

shery
Starting Member

5 Posts

Posted - 2011-08-17 : 05:23:44

SQL_Latin1_General_CP1_CI_AS

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2011-08-17 : 05:30:34

I'd be surprised if that collation can even store/display Hiragana, Katakana & Kanji characters, never mind sort them....but I'm not an internationalisation expert.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-17 : 05:53:53

try using Japanese_Bushu_Kakusu_100_

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

shery
Starting Member

5 Posts

Posted - 2011-08-17 : 08:17:56

I use SQL 2005 and it doesn't have collation "Japanese_Bushu_Kakusu_100"
I can't change the collation to Japanese becasue my table has also journals in English!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources