doob
Posts: 7
|
| Posted: 06/08/2006, 1:10 AM |
|
Please excuse my ignorance, but I don't quite understand the following situation:
I'm using CCS with ASP on SQL-Server 2000. When using <Connection>.ToSQL with type = ccsText ode ccsMemo the resulting String looks like N'foo'. What does the N mean in SQL (ist it SQL-Server specific?). I have discovered that my queries run substantially faster if I remove the leading N from the query.
|
 |
 |
DonB
|
| Posted: 06/08/2006, 9:32 AM |
|
That's a Unicode specifier. Thus, there's data transformation to/from
Unicode involved. Without the N it's plain, single-byte ASCII.
--
DonB
http://www.gotodon.com/ccbth
"doob" <doob@forum.codecharge> wrote in message
news:64487db6cb3aa0@news.codecharge.com...
> Please excuse my ignorance, but I don't quite understand the following
> situation:
> I'm using CCS with ASP on SQL-Server 2000. When using <Connection>.ToSQL
with
> type = ccsText ode ccsMemo the resulting String looks like N'foo'. What
does
> the N mean in SQL (ist it SQL-Server specific?). I have discovered that my
> queries run substantially faster if I remove the leading N from the query.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
