jump to navigation

NOTE: The spam filter is being unusually aggressive. If you comment does not immediately appear, it has simply been placed in moderation and I will approve it as quickly as possible. Thank you for your patience.

"Murphy was an optimist!"

Of Being Dad May 28, 2008 10:46 pm

Posted by Doug McCaughan in : Amy, Daily Life, Family, Of Being Dad
, 4comments

Dear child, if you put chewing gum behind your ear so that you can brush your teeth, you will have gum stuck in your hair. Love, Dad

4comments

Collation? May 28, 2008 5:19 am

Posted by Doug McCaughan in : MS SQL, Programming, Technology
, add a comment

You mean like getting the papers from the copier in order?

You know, I have probably exported and imported data from hundreds of databases at this point in my life. And never, I say never, have I ever had a collation problem. Collation has to deal with how a database handles issues of sort order, case sensitivity, and sensitivity to accents. It becomes important when your database is not US centric or is going to serve an International audience. Last night it got me.

I tried directly updating data on a server that is probably located in Amsterdam and ended up with:

Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation

Ugh.

add a comment