RE: N prefex in a non-unicode database
- From: v-mingqc@xxxxxxxxxxxxxxxxxxxx (Michael Cheng [MSFT])
- Date: Tue, 19 Jul 2005 10:16:24 GMT
Hi Kiran,
Thanks for your update.
- My doubt here is, can we use N'' for varchar/char types?
No, it is not recommanded to do so. But if your database is an English one
and it works for most times, it think it's OK if you leave them what they
used to be.
Yes, I have realized SQL cannot handle the NULL values after convert() but
not sure why. I will let our development guys know about this.
Thanks for your patience and cooperation.
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.
.
- References:
- N prefex in a non-unicode database
- From: kiran_yalla
- RE: N prefex in a non-unicode database
- From: Michael Cheng [MSFT]
- RE: N prefex in a non-unicode database
- From: kiran_yalla
- RE: N prefex in a non-unicode database
- From: kiran_yalla
- N prefex in a non-unicode database
- Prev by Date: Re: filtering data
- Next by Date: Re: Comparing a pair
- Previous by thread: RE: N prefex in a non-unicode database
- Index(es):
Relevant Pages
|
|
