Niagara Falls

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ron Moses » Niagara Falls

64 posts, Page 1 of 7

1 2 3 4 5 »»»

Niagara Falls

Rate Topic

Display Mode

Topic Options

Author

Message

ronmoses

Posted Saturday, July 30, 2011 2:35 PM

SSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 651, Visits: 687

Comments posted to this topic are about the item Niagara Falls

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

Post #1151474

bitbucket-25253

Posted Saturday, July 30, 2011 9:16 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 5,103, Visits: 20,213

Whopeee first one to select the correct answer. (not a guess).

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1151495

Paul White

Posted Sunday, July 31, 2011 12:07 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 10,990, Visits: 10,540

Excellent question...most intriguing. Thanks.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1151510

L' Eomot Inversé

Posted Sunday, July 31, 2011 3:36 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 7,108, Visits: 7,179

Very interesting question.

I knew the behaviour with the windows collation (no sql_ prefix to the collation name) because that's the collation I've worked with more than any other (in fact it's the only collation I've worked with since varchar(max) existed). I didn't know the behaviour with the other collation, but there was only one option with "hang" in it so I picked that one.

So now I've learned something - the other collation works better for this weird case.

Tom
Is minic a gheibheann béal oscailt dorn dúnta.

Post #1151520

bitbucket-25253

Posted Sunday, July 31, 2011 6:46 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 5,103, Visits: 20,213

Even stranger, used NVARCHAR(max) and the behavior is completely different.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1151523

ronmoses

Posted Sunday, July 31, 2011 7:44 AM

SSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 651, Visits: 687

bitbucket-25253 (7/31/2011)

Even stranger, used NVARCHAR(max) and the behavior is completely different.

I noticed that too, and it inspired me to search my code for any varchars and change them to nvarchars, just in case. Given the relatively small size of our database, there's little downside that I can see.

I work in the US, so this didn't manifest itself until one of our Canadian customers reported that an import process from Access was taking a very long time. I couldn't reproduce the problem until I took the step of setting up a server with Canadian collation. Once I isolated that REPLACE() as the culprit, I knew I had a good QotD on my hands. Wink

ron

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

Post #1151526

bitbucket-25253

Posted Sunday, July 31, 2011 9:02 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 5,103, Visits: 20,213

ronmoses

Have you reported this anomaly to Microsoft Connect?

http://connect.microsoft.com/

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1151531

mohammed moinudheen

Posted Sunday, July 31, 2011 11:10 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:28 AM
Points: 2,170, Visits: 3,583

Surprising to see so many comments on a Sunday :)

Mohammed Moinudheen

Post #1151538

Nakul Vachhrajani

Posted Sunday, July 31, 2011 10:57 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:02 AM
Points: 1,277, Visits: 1,609

Thank-you for the interesting question!

It is strange that VARCHAR(MAX) would behave differently. Has this ever been reported to Connect?

Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1151600

David in .AU

Posted Sunday, July 31, 2011 11:57 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, March 17, 2013 5:34 PM
Points: 521, Visits: 543

This article might be interesting: note the reply from microsoft at the bottom

Replace of char(0) does not work in DB with Windows collation

I know it isn't exactly the same issue, but it runs along the same lines...

Post #1151616

« Prev Topic | Next Topic »

64 posts, Page 1 of 7

1 2 3 4 5 »»»

Permissions