Post reply

What does N... mean?

  • February 10, 2004 at 2:18 pm

    #107264

    I see queries where a capital N precedes strings in single quotes. Ie:

    OBJECTPROPERTY

    (id, N'IsProcedure')

    What does the N do? I can't find any reference to it in Books Online.

     

    Thanks

    Ben

  • February 10, 2004 at 2:31 pm

    #493498

    'N' casts the string as a double-byte string (two bytes per character, international language support).  The destination field is type nchar, nvarchar, etc. 

  • February 10, 2004 at 5:25 pm

    #493534

    Also known as UNICODE DataType!

    Look in BOL for more info!

    Kindest Regards,

  • February 11, 2004 at 2:43 am

    #493577

    So am I correct in thinking that if I'm dealing with international (non-english) databases that I want to treat everything as unicode?

    Ben

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply