Home > IT Answers > SQL Server > Store and retrieve data from SQL Server 2005 ...
MrGeorge
65 pts.
 Store and retrieve data from SQL Server 2005 in UTF-8
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  10:43 AM GMT
UPDATED: February 28, 2012  8:39:23 AM GMT
RELATED QUESTIONS
MTidmarsh
150 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Feb 7, 2012  3:39 PM (GMT)  by  MTidmarsh   150 pts.
Latest Answer Wiki Contributors:  Prettyshina   1,330 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

[...] MrGeorge tries to figure out how to store and retrieve data from a 2005 SQL Server in [...]

The Most-Watched IT Questions: February 15, 2012 - ITKE Community Blog
 0 pts.
 

[...] MrGeorge needs help to store and retrieve data in UTF-8 on SQL Server [...]

The Most-Watched IT Questions: March 6, 2012 - ITKE Community Blog
 0 pts.