How can i select urdu data from table in SQL Plus
Dear Sir,
I m using Oracle 8i with windows Xp platforum (regional language urdu)
SQL>select * from v$nls_parameters;
PARAMETER VALUE
------------------------------ ------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET AR8MSWIN1256
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 TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:T
ZM
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AR8MSWIN1256
NLS_COMP BINARY
SQL>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 AR8MSWIN1256
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 TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:T
ZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET AR8MSWIN1256
NLS_RDBMS_VERSION 8.1.7.0.0
in the regsitry NLS_LANG AMERICAN_AMERICA.AR8MSWIN1256
CREATE TABLE UTABLE (
URDUDATA VARCHAR2(100)
);
INSERT INTO UTABLE
VALUES('مسرور ');
I m facing the problem when i
SQL> select urdudata from utable;
URDUDATA
-----------------
????????
WHEN I M INSERTING WITH NVARCHAR2(100)
ERROR RETURN character set mismatch
kINDLY HELP IN THIS REGARD
I SHALL BE VERY GRATEFUL OF YOU