Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Unicode Enabled

0 views
Skip to first unread message

Sierra

unread,
Dec 6, 2004, 8:31:34 AM12/6/04
to
Hi guys

I want to know how to check if a particular database and its tables, related
scripts, stored procedures, etc are Unicode-enabled.

Is there any place/tools where i can find some statergies and plans for the
above

Regards

Sierra


Bart Duncan [MSFT]

unread,
Dec 6, 2004, 11:31:40 AM12/6/04
to
A column can store Unicode data if its data type is nchar, nvarchar, or
ntext. Columns of type char, varchar, or text cannot store Unicode data.
You can query the data types of the tables in a database using the
INFORMATION_SCHEMA views:

USE pubs
GO
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
GO

HTH,
Bart
------------
Bart Duncan
Microsoft SQL Server Support

Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| From: "Sierra" <senthilve...@yahoo.com>
| Subject: Unicode Enabled
| Date: Mon, 6 Dec 2004 19:01:34 +0530
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <ufjzpf52...@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.tools
| NNTP-Posting-Host: fw-us-hou19.bmc.com 198.207.223.240
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!new
sfeed1.ip.tiscali.net!news.maxwell.syr.edu!wn14feed!worldnet.att.net!204.71.
34.3!newsfeed.cwix.com!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.tools:26309
| X-Tomcat-NG: microsoft.public.sqlserver.tools

0 new messages