Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Advanced
Jun 28, 1999

Unicode Support in SQL Server 7.0 Simplifies International Localization

SQL Server 7.0 includes full Unicode support, which simplifies international localization. N is the Transact SQL (T-SQL) shorthand that tells SQL Server you're referencing a Unicode string. In this example, sp_addlinkedserver is used to create a linked server named MyServer. This command has Unicode support while translating the 'SQL Server' string:

 
          USE master

          GO

          EXEC sp_addlinkedserver
               'MyServer',
                N'SQL Server'
          GO

where 'MyServer' is the name of the linked server to create and 'SQL Server' is the product name of the OLE DB data source to add as a linked server. The N prefix tells SQL Server to use the Unicode character set to translate the 'SQL Server' string. The N prefix isn't necessary if you use the same code page on all your clients and servers and don't deal with language localization problems. However, Unicode works well if you're not sure whether you're using the same code page on all your clients and server.

Jai Bardhan
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date