plz help

Re: plz help

"situ" <SRIDHARA.S@RED IFFMAIL.COM> wrote in message
news:1150788121 .200248.35190@p 79g2000cwp.goog legroups.com...[color=blue]
> would any body help me to create a database in utf codeset which
> supports japanese language and settings involved in them.
>
> thanks and regards
> situ
>[/color]


CREATE DATABASE SAMPLE ON 'C:' USING CODESET UTF-8 COLLATE USING
IDENTITY_16BIT;

When crating tables, your CHAR and VARCHAR columns that will hold Japanese
will need to be defined about 3 times as large as the equivalent Roman
characters.

Re: plz help


thanks, one more thing
here does it require to mention TERRITORY option in create database
command
and does it require to make some regional settings for japanese
language.

Re: plz help

"situ" <SRIDHARA.S@RED IFFMAIL.COM> wrote in message
news:1150790021 .955368.191350@ b68g2000cwa.goo glegroups.com.. .[color=blue]
>
> thanks, one more thing
> here does it require to mention TERRITORY option in create database
> command
> and does it require to make some regional settings for japanese
> language.
>[/color]

You can use whatever territory option you want and still use Japanese. The
territory code will effect things such as how dates are displayed, the use
of commas vs. periods in numbers, etc.

Of course these things can be overridden in your SQL, such as requesting
that dates be displayed in a particular format regardless of the territory
code (see the CHAR function in SQL Reference Vol 1).

Re: plz help

thanks