字符串文字上的 SQL Server T-SQL N 前缀 [英] SQL Server T-SQL N prefix on string literal

问题描述

这可能是一个菜鸟问题，但我发现了一些 T-SQL 查询示例，可以使用 SELECT 和 WHERE 子句 此处

It's maybe a noob question but I found some T-SQL query example to verify database size with SELECT and WHERE clause here

代码如下:

SELECT name, size, size*1.0/128 AS [Size in MBs] 
FROM sys.master_files
WHERE name = N'mytest';

我的问题是 WHERE name = N'keyword' 子句中的 N 前缀是什么意思?

My question is what does the N prefix mean in the WHERE name = N'keyword' clause?

我之前一直用WHERE name = 'keyword'，没发现有什么不同(大家可以自己试一下).

I always use WHERE name = 'keyword' before, and I don't find the differences (you can try it by yourself).

我用谷歌搜索过，但我不知道我应该搜索的关键字

I've googled that but I don't know the keyword I supposed to search

推荐答案

它将字符串声明为 nvarchar 数据类型 (Unicode)，而不是 varchar(8 位编码，包括 ASCII).

It's declaring the string as nvarchar data type (Unicode), rather than varchar (8-bit encoding, including ASCII).

仅供参考，这是问题的副本:前缀N是什么意思在 T-SQL 语句中?

FYI, this is a duplicate of the question: What is the meaning of the prefix N in T-SQL statements?

这篇关于字符串文字上的 SQL Server T-SQL N 前缀的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！