• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

what does the N stand for in dbcc shrinkdatabase(N'pubs')

Hi,

Doea anyone know what does the N stand for in dbcc shrinkdatabase(N'pubs') ?

thanks
H
0
hraja77
Asked:
hraja77
1 Solution
 
cpleong99Commented:
N'pubs' is still a 'pubs' string.

the N' tells the SQL that it is a uni-code string.

I use N to supporting 2 bytes characters wording, such as Chinese wording.
For example,
select * from table1 where ItemName = N'ÅN'


0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now