Imar,

I'm wondering if you have ever seen this before? When I enter a Filter per your instructions, LIKE '%rock%' and capital N is inserted immediately before the 1st percent (%) sign. I can manually remove it, however, as soon as I tab or move away from the Filter column, it is immediatley re-inserted.

It doesn't matter what I type between the percent signs, a capital N is always inserted before the 1st apostrophe. Refer to the title of this message to see exactly what I'm describing to you.

I think it must be a bug in Visual Studio 2010.

Your thoughts, please.

J. Koyle

Imar,

I forgot to mention, the code works perfect, even with the capital N inserted. That's whats' so confusing.

Sorry for the 2nd message.

J. Koyle

It's not a bug in VWD (sorry, Visual Web Developer Express Edition), it's by design. The data type in your SQL database (sorry, Structured Query Language database) is of type nvarchar which is designed to store unicode data. The standard of telling SQL Server (sorry, Structured Query Language Server) that some piece of text is unicode is to prefix it by the captial N. So, N'I hate acronyms' is a perfectly piece of unicode data.

In most situations, you can simply leave it out and it'll still work. VWD (sorry, Visual Web Developer) just makes it explicitly for you.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks Imar,

Now it makes sense.

J. Koyle