June 7, 2013 at 2:49 pm
Does SQL server 2008 R2 support UTF-8 character encoding ?
Thanks.
June 7, 2013 at 2:55 pm
sudhakara (6/7/2013)
Does SQL server 2008 R2 support UTF-8 character encoding ?Thanks.
Yes. nchar and nvarchar
http://msdn.microsoft.com/en-us/library/ms186939.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 8, 2013 at 10:22 am
sudhakara (6/7/2013)
Does SQL server 2008 R2 support UTF-8 character encoding ?Thanks.
No, not natively. SQL Server supports UCS-2 which is a subset of UTF-16 for Unicode data. In 2012 there is some support for supplementary characters via specialized collations, but still nothing specifically for UTF-8.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 12, 2013 at 3:58 am
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy