RE: What does "N" do in a WHERE clause?

From: Sheehan, Heath <heath.sheehan_at_intergraph.com>
Date: Wed, 21 Mar 2007 10:46:35 -0600
Message-ID: <ED3B795A56D8C64EAFF6B7042273D4240219EF47@US-MAIL.ingrnet.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Wednesday, March 21, 2007 11:02 AM To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 21 2007 - 11:46:35 CDT