Home » SQL & PL/SQL » SQL & PL/SQL » How to Fetch data on the basis of Unicode Characters
How to Fetch data on the basis of Unicode Characters [message #363344] Sat, 06 December 2008 00:02 Go to next message
neal9896
Messages: 3
Registered: December 2008
Junior Member
Hi, i m unable to fetch data on the basis of Unicode characters.

Select 1 from ps_cc_flat where admin1_name ='TÜRKIYE'.

In this table Data is present with this name.But i m unable to fetch using this query.
Re: How to Fetch data on the basis of Unicode Characters [message #363347 is a reply to message #363344] Sat, 06 December 2008 00:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From which client?
What is your database character set?
What is your OS character set?
What is your NLS_LANG?
What is your client character set (at OS level)?
Maybe you are just bad configured:
SQL> select * from t where id='TÜRKIYE';
ID                          VAL
-------------------- ----------
TÜRKIYE                       1

1 row selected.

Regards
Michel

Re: How to Fetch data on the basis of Unicode Characters [message #363350 is a reply to message #363347] Sat, 06 December 2008 00:37 Go to previous messageGo to next message
neal9896
Messages: 3
Registered: December 2008
Junior Member
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 AL32UTF8
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
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_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
Re: How to Fetch data on the basis of Unicode Characters [message #363355 is a reply to message #363350] Sat, 06 December 2008 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is this?
Why don't you also post your socks color?

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Use SQL*Plus and copy and paste your session.

Regards
Michel
Re: How to Fetch data on the basis of Unicode Characters [message #363369 is a reply to message #363347] Sat, 06 December 2008 04:41 Go to previous messageGo to next message
neal9896
Messages: 3
Registered: December 2008
Junior Member
NLS_LANGUAGE= AMERICAN

CharacterSet=AL16UTF16



Re: How to Fetch data on the basis of Unicode Characters [message #363380 is a reply to message #363369] Sat, 06 December 2008 09:26 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
From which client?
What is your database character set?
What is your OS character set?
What is your NLS_LANG?
What is your client character set (at OS level)?

5 precise questions so at least 5 answers to these questions.

Regards
Michel
Previous Topic: doubt about explain plan
Next Topic: Server Date format
Goto Forum:
  


Current Time: Mon Dec 05 06:35:20 CST 2016

Total time taken to generate the page: 0.09868 seconds