Connecting Tech Pros Worldwide Help | Site Map

What is the N in front of the string?

shumaker@cs.fsu.edu
Guest
 
Posts: n/a
#1: Nov 13 '05
When I'm writing query statements in Access it adds an N in front of my
strings. What does this denote?

pietlinden@hotmail.com
Guest
 
Posts: n/a
#2: Nov 13 '05

re: What is the N in front of the string?


could you post an example of this? I've never seen what you describe.

Trevor Best
Guest
 
Posts: n/a
#3: Nov 13 '05

re: What is the N in front of the string?


shumaker@cs.fsu.edu wrote:[color=blue]
> When I'm writing query statements in Access it adds an N in front of my
> strings. What does this denote?
>[/color]

I assume you're using an ADP.

It's a casting identifier for SQL Server:

'Hello' is taken as varchar
N'Hello' is taken nvarchar (unicode)


--
[Oo=w=oO]

Closed Thread