Re: character set problem in Oracle 10g

tri dhungana via DBMonster.com wrote:

> I have just install oracle 10g Enterprise Edition in winXp and my character
> set on the db server is
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Sat May 7 07:12:17 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> Enter password: ******
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> select * from nls_database_parameters;
>
> PARAMETER VALUE
> ------------------------------ ---------------------------------------
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_CHARACTERSET WE8MSWIN1252
> NLS_CALENDAR GREGORIAN
> NLS_DATE_FORMAT DD-MON-RR
> NLS_DATE_LANGUAGE AMERICAN
> NLS_SORT BINARY
> NLS_TIME_FORMAT HH.MI.SSXFF AM
>
> PARAMETER VALUE
> ------------------------------ ---------------------------------------
> NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
> NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
> NLS_DUAL_CURRENCY $
> NLS_COMP BINARY
> NLS_LENGTH_SEMANTICS BYTE
> NLS_NCHAR_CONV_EXCP FALSE
> NLS_NCHAR_CHARACTERSET AL16UTF16
> NLS_RDBMS_VERSION 10.1.0.2.0
>
> i am using some other fonts that resemble like Hindi.Now how can i change
> my character set on db server. I have tried using
> Local builder....i could not get it right......can anyone tell me.....

The instructions can be found at http://tahiti.oracle.com. This is not so much an RTFM as it is the fact that I don't recall the exact steps off the top of my head as I don't do it more than once each year.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)