You can check the collation on your db with:

(code from Pinal Dave)

SELECT

c.name

,c.collation_name

FROM

sys.columns c

WHERE

OBJECT_ID IN

(

SELECT

OBJECT_ID

FROM

sys.objects o

WHERE

type = 'U'

AND o.name = 'YourTableName'

)

Just for reference, on my machine the collation is 'SQL_Latin1_General_CP1_CI_AS'.