text data type in SQL server represents:
Variable-length non-Unicode data in the code page of the server and with a maximum string length of 2^31-1 (2,147,483,647). (emphasis mine)
So, because GoDaddy has a different code page on the server than you do, the unicode chars are getting mangled.
text was never meant to contain unicode.
You need to use
As DJ Kraze correctly noted, prefixing your strings with N might also be necessary (I thought it might help to add the explanation). But since you are using LINQ to SQL, that's not the problem in your case (good catch @Jon Hanna, I missed that tag).