Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

UTF-8 Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 3:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 03, 2014 7:43 AM
Points: 262, Visits: 942

Can any one tell me
is it possible to enable UTF-8 for the SQL databases .If yes ,where can i see it...on sql server.
we are using sql 2008

Thanks
Post #1346428
Posted Friday, August 17, 2012 7:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 3,683, Visits: 4,818
Please bear in mind that while SQL Server supports UCS-2 and UTF-16 in the NCHAR & NVARCHAR data types, UTF-8 is currently not supported.
MS have advised they are looking at this, but no conclusive answer to date.
consider converting the UTF-8 character columns to UCS-2 for inserting into SQL Server


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1346542
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse