RE: What does "N" do in a WHERE clause?
- From: "Sheehan, Heath" <heath.sheehan@xxxxxxxxxxxxxx>
- To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Mar 2007 10:46:35 -0600
The N casts the literal string as a NCHAR or NVARCHAR2 datatype, which
makes sure its value is encoded using the database's national character
set.
Heath
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse
Sent: Wednesday, March 21, 2007 11:02 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: What does "N" do in a WHERE clause?
Hey all,
Getting used to a new Oracle 10.1.0.5.0 environment and am finding new
and fun things every day. The latest I found is a SELECT statement,
generated by Crystal Enterprise 10 if it matters, that has an odd syntax
that I haven't seen before. Here's a snip:
WHERE NOT( MYTAB"."SDLNTY" = N'F'
OR "MYTAB"."SDLNTY" = N'NS' )
AND "MYTAB"."SDNXTR" < N'999'
AND "MYTAB"."SDECST" = 0
The part that caught my eye in this loosely veiled query piece is the
"N"
modifier, or whatever it is. It doesn't look like a function, but it
seems to be acting like CAST(). If it's important, the SQL is in ANSI
syntax.
There's nothing that I could find browsing the SQL Reference doc and
trying to Google "ANSI SQL N" didn't help, either. ;)
Anyone seen this before?
TIA!
Rich
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
