Re: Unicode Encoding in SQL Server 2005 (Yukon)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Erland Sommarskog (sommar_at_algonet.se)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 23:40:39 +0000 (UTC)

Jim Lewis (j_jim_lewis@hotmail.com) writes:
> I have a question about how Unicode will be stored in SQL Server 2005
> (Yukon). SQL Server 2000 encodes and stored Unicode as UCS2. Will
> SQL Server 2005 (Yukon) be able to encode and store Unicode data as
> UTF-8?

No. 

-- 
Erland Sommarskog, SQL Server MVP, sommar@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • Re: SQLOLEDB handling Japanese data...
    ... >> to other Japenese SQL server B. Here, ... > UTF-8 you bind as Unicode, ... > you always perform a WideCharToMultiByte, ... > Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: SQL 2008 - FILESTREAM OpenSQLFilestream invalid handle
    ... I fill the path in a table trigger and it's not a Unicode data. ... pass to OpenSqlFilestream must be a pointer to a Unicode string. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • Re: SQLOLEDB handling Japanese data...
    ... > Thanks for your valuable repsonse. ... > we had bound varcharas unicode during creating ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Migrating plain text file into SQL Server
    ... You can use DTS, bcp or other bulk upload methods available. ... Books Online for SQL Server SP3 at ... > What do I need in order to import text files into SQL Server? ...
    (microsoft.public.sqlserver.tools)
  • Re: Incorrect syntax in user-defined function
    ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server SP3 at ... Prev by Date: ...
    (comp.databases.ms-sqlserver)