Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> character set problem in Oracle 10g

character set problem in Oracle 10g

From: tri dhungana via DBMonster.com <forum_at_nospam.DBMonster.com>
Date: Sat, 07 May 2005 14:28:41 GMT
Message-ID: <221c37180f454d27ada332cde4938a37@DBMonster.com>


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

-- 
Message posted via http://www.dbmonster.com
Received on Sat May 07 2005 - 09:28:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US