Question regarding SQL Query Editor
I am designing a query using the Query Editor in SQL server.
I am querying a table and putting a filter on a nvarchar column.
If I type a value into the filter column, for example '12', the editor changes it to N'12'.
why is it doing this? What does the "N" signify?
I am querying a table and putting a filter on a nvarchar column.
If I type a value into the filter column, for example '12', the editor changes it to N'12'.
why is it doing this? What does the "N" signify?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
N (nchar, nvarchar, ntext) signifies Unicode, meaning it handles a larger number of characters then non-unicode, and each character takes two bytes in memory instead of one.
Typically this is needed when dealing with foreign language collations.
>If I type a value into the filter column, for example '12', the editor changes it to N'12'.
Curiosity overwhelms me ... if you have a column that you'd want to filter on '12', then why is it a character data type as opposed to numeric?
Typically this is needed when dealing with foreign language collations.
>If I type a value into the filter column, for example '12', the editor changes it to N'12'.
Curiosity overwhelms me ... if you have a column that you'd want to filter on '12', then why is it a character data type as opposed to numeric?
Premium Content
You need an Expert Office subscription to comment.Start Free Trial