Home All Groups Group Topic Archive Search About
Author
15 Jul 2005 4:55 PM
Bernie Yaeger
What is the meaning/use of an n' prefix like this:

select N'fname, N'lname for customers

tx for any help

Bernie Yaeger

Author
15 Jul 2005 5:22 PM
Gail Erickson [MS]
Unicode constants are specified with a leading N.   See the topic 'Using
Unicode Data' in SQL Server Books Online for details.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Show quote
"Bernie Yaeger" <bern***@cherwellinc.com> wrote in message
news:ujVFS4ViFHA.1788@TK2MSFTNGP12.phx.gbl...
> What is the meaning/use of an n' prefix like this:
>
> select N'fname, N'lname for customers
>
> tx for any help
>
> Bernie Yaeger
>
>
Author
15 Jul 2005 5:36 PM
Bernie Yaeger
Tx Gail,

Bernie

Show quote
"Gail Erickson [MS]" <ga***@online.microsoft.com> wrote in message
news:uyNiKHWiFHA.3336@tk2msftngp13.phx.gbl...
> Unicode constants are specified with a leading N.   See the topic 'Using
> Unicode Data' in SQL Server Books Online for details.
>
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Bernie Yaeger" <bern***@cherwellinc.com> wrote in message
> news:ujVFS4ViFHA.1788@TK2MSFTNGP12.phx.gbl...
>> What is the meaning/use of an n' prefix like this:
>>
>> select N'fname, N'lname for customers
>>
>> tx for any help
>>
>> Bernie Yaeger
>>
>>
>
>
Author
15 Jul 2005 5:25 PM
Aaron Bertrand [SQL Server MVP]
http://www.aspfaq.com/2522




Show quote
> What is the meaning/use of an n' prefix like this:
>
> select N'fname, N'lname for customers
>
> tx for any help
Author
15 Jul 2005 5:36 PM
Bernie Yaeger
Tx Aaron,

Bernie

Show quote
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OUrgfIWiFHA.3336@tk2msftngp13.phx.gbl...
> http://www.aspfaq.com/2522
>
>
>
>
>> What is the meaning/use of an n' prefix like this:
>>
>> select N'fname, N'lname for customers
>>
>> tx for any help
>
>
Author
15 Jul 2005 5:53 PM
Sericinus hunter
Bernie Yaeger wrote:
> What is the meaning/use of an n' prefix like this:
>
> select N'fname, N'lname for customers
>
> tx for any help

    It stands for "national" which is supposedly the old way of
saying "unicode".

AddThis Social Bookmark Button