Please tell me the meaning of N' 
Author Message
 Please tell me the meaning of N'
Hello,
Please tell me the meaning of N' in the following statement.
For I cannot find the explanation in the BOL.


Thanks in advance



Thu, 05 Dec 2002 03:00:00 GMT
 Please tell me the meaning of N'

This is the way of specifying a Unicode constant.   It is used in nchar,
nvarchar and next.

    Tom

--------------
Hello,
Please tell me the meaning of N' in the following statement.
For I cannot find the explanation in the BOL.


Thanks in advance



Thu, 05 Dec 2002 03:00:00 GMT
 Please tell me the meaning of N'
 It means it is a unicode string rather than ascii

 > Please tell me the meaning of N' in the following statement.

Quote:
> For I cannot find the explanation in the BOL.


> Thanks in advance

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (428 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq


Thu, 05 Dec 2002 03:00:00 GMT
 Please tell me the meaning of N'
In addition to the posts by Tom and Neil, in the section "Using Unicode Data" in
the SQL Server 7.0 Books Online appears the following ...

"Note The n prefix for these data types comes from the SQL-92 standard for
National (Unicode) data types."

---------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be
cut and pasted into Query Analyzer is appreciated.


Quote:
> Hello,
> Please tell me the meaning of N' in the following statement.
> For I cannot find the explanation in the BOL.


> Thanks in advance



Thu, 05 Dec 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Please tell me what this error means:

2. Please tell me about the '.MDX'

3. Please tell me why I can't compile or run sdk

4. Please tell me what I'm doing wrong

5. Can anyone tell me what this means?

6. Can any body tell me what ~s meaning of COM, MTS and ADO

7. Can any body tell me what ~s meaning of COM, MTS and ADO

8. Can u tell me what this error means?

9. Can anyone tell me what this means?

10. Oracle jobs in Halifax, NS, Fredericton, NB, Moncton, NB, St. John's, NF

11. Oracle jobs in Halifax, NS, Fredericton, NB, Moncton, NB, St. John's, NF

12. Tandem's NS-SQL to DB2 Data transfer


 
Powered by phpBB® Forum Software