What is the N in front of the string?

#1 November 13th, 2005, 09:58 AM

When I'm writing query statements in Access it adds an N in front of my
strings. What does this denote?

#2 November 13th, 2005, 09:58 AM

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

#3 November 13th, 2005, 09:58 AM

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]

What is the N in front of the string?

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

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

/bytes/development

/bytes/it

/bytes/about