I need to store few japan charactors.
i.e. 焼尻
now i am not sure which of the following Collation / Charactor_seto to select in the table for above Japan charactors.

Sjis
sjis_Bin
sjis_apanese_ci

or

Ujis
ujis_Bin
Ujis_japanies_ci
?

BTW, What is this Sjis & Ujis mean ?

I believe if you use UTF-8 that you'll be covered for most character types.

Thanks VirtuosiMedia,
yes i am using utf8 as default. but it does not support japanies charactors it looklike.

Actually you want Unicode, or UTF-16.

The number after the UTF is the number of bytes per character. ASCII is 7, and most of what we're used to can be expressed as 8. Obviously, 8 bits gives 2x the chars as 7 bits. A lot of accent chars, like in French, fit inside the 8 bit charset. But extended ones don't.

Unicode is stored as nvarchar and ntext and nchar types. The n means national, it gives you 65 K instead of 256 characters, by storing them as double byte. This means more disc IO to manipulate the data, but it gives you a much bigger alphabet to express your data with.