Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> character set problem in Oracle 10g
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.comReceived on Sat May 07 2005 - 09:28:41 CDT