plz help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

situ - 20 Jun 2006 08:22 GMT

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

Reply to this Message

Mark A - 20 Jun 2006 08:47 GMT

> 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

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.

Reply to this Message

situ - 20 Jun 2006 08:53 GMT

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.

Reply to this Message

Mark A - 20 Jun 2006 09:00 GMT

> 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.

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).

Reply to this Message

situ - 20 Jun 2006 09:14 GMT

thanks

Reply to this Message