65 pts.
POSTED: Apr 8, 2012 3:48 AM (GMT)
Store and retrieve data in UTF-8 on SQL Server 2005
(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
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
ASKED:
Feb 3, 2012 11:11 AM GMT
UPDATED:
April 8, 2012 3:48:29 AM GMT
RELATED QUESTIONS
- Store and retrieve data from SQL Server 2005 in UTF-8
- The most-watched IT questions this week: Dec. 8, 2009
- How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?
- Error when insertin.g data into SQL table
- Receiving result sets in RPG (prior to release 7.1) from an SQL SP
- loading csv files into Oracle tables
- Why can't I connect to SQL Server 2005 through ODBC ?
- Retrieve data from Oracle9i to SQL server
- Database Best Practices for index values
- How to Display Japanese character in Crystal Report 8.5
Answer Wiki:
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.
To see other answers submitted to the Answer Wiki View Answer History.
