RE: N prefex in a non-unicode database

Thanks Michael for the info.

My doubt here is, can we use N’%’ for varchar/char types? We generalized our
application earlier to generate N prefixed string constants irrespective of
whether the type is nvarchar/nchar or varchar/char. I would like to know if
this generalization is valid or not.

Regards,
Kiran


"Michael Cheng [MSFT]" wrote:

> Hi Kiran,
>
> Welcome to use MSDN Managed Newsgroup!
>
> 'N' is used to represent Unicode character so when you use N'%' it
> indicates that the potential data types that you are using is either
> nvarchar or nchar (both are used to support unicode character sets) where
> are when we use '%' the data types would be char or varchar.
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
.