Store and retrieve data in UTF-8 on SQL Server 2005

65 pts.
Tags:
SQL Server 2005
UTF-8
(Apologies:I put this question under Windows Server 2003 tag by mistake, so I copied and pasted it here where it should be) I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table SQL makes it into question marks ???. What should I do to be able to store and read UTF-8 data? My columns are all NVARCHAR(MAX). I anticipate that my database will need to store other languages too through a scripting language (ASP Classic in this case). How do I tell SQL Server 2005 to support more than one language for storing and retrieving data?

Software/Hardware used:
SQL Server 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

I had found a way to do it after messing around with it a bit more so I thought I put it here for others to see even though it’s been a few days now. In SQL Management Studio I right-clicked on the database in object explorer and chose Properties->Options->Collation. Then chose a certain language, in this case Greek_BIN. Now the database can accept UTF-8 characters. I am using this to receive responses from PayPal. I doubt if that is what I was originally aiming for but right now it suits my needs.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ruru1314
    How do I tell SQL Server 2005 to support more than one language for storing and retrieving data?
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following