Checklist for SQL Server

Hi guys
Can anyone provide me some checklist to verify that SQL 2000 is unicode
enabled . In short how do i test the same
Help is appreciated !
Regards
Sierra
Hi Dan
Thanks for the response
I want to know how to check if a particular database and its tables,
related scripts, stored procedures, etc are Unicode-enabled in SQL 2000
Do you have any info on Test Statergy for the same
Regards
Sierra
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ezaPjOP2EHA.1192@.tk2msftngp13.phx.gbl...
> Perhaps I don't fully understand your question but all SQL Server 2000
> instances are 'unicode enabled'. One can store unicode data in nchar,
> nvarchar or ntext data types.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
> news:%23q3lulO2EHA.3392@.TK2MSFTNGP10.phx.gbl...
>
|||The scripts below will identify non-unicode character types in tables and
views as well as stored procedure and function parameters.
It's probably best to perform unicode testing as part of your overall
application testing strategy. Include unicode test data and cases in your
testing suite. This will identify issues with application code as well as
SQL objects and scripts.
--list character columns not unicode types
SELECT TOP 10
c.TABLE_SCHEMA,
c.TABLE_NAME,
c.COLUMN_NAME,
c.DATA_TYPE
FROM INFORMATION_SCHEMA.TABLES t
JOIN INFORMATION_SCHEMA.COLUMNS c ON
c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
c.TABLE_NAME = t.TABLE_NAME
WHERE
c.DATA_TYPE IN('char', 'varchar', 'text') AND
t.TABLE_TYPE = 'BASE TABLE'
--list stored procedure and function character parameters not unicode types
SELECT TOP 10
SPECIFIC_SCHEMA,
SPECIFIC_NAME,
PARAMETER_NAME,
DATA_TYPE
FROM INFORMATION_SCHEMA.PARAMETERS
WHERE
DATA_TYPE IN('char', 'varchar', 'text')
Hope this helps.
Dan Guzman
SQL Server MVP
"Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
news:u0a4ka52EHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi Dan
> Thanks for the response
> I want to know how to check if a particular database and its tables,
> related scripts, stored procedures, etc are Unicode-enabled in SQL 2000
> Do you have any info on Test Statergy for the same
> Regards
> Sierra
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:ezaPjOP2EHA.1192@.tk2msftngp13.phx.gbl...
>
|||Thanks Dan
Sierra
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ebiT3252EHA.3932@.TK2MSFTNGP12.phx.gbl...
> The scripts below will identify non-unicode character types in tables and
> views as well as stored procedure and function parameters.
> It's probably best to perform unicode testing as part of your overall
> application testing strategy. Include unicode test data and cases in your
> testing suite. This will identify issues with application code as well as
> SQL objects and scripts.
> --list character columns not unicode types
> SELECT TOP 10
> c.TABLE_SCHEMA,
> c.TABLE_NAME,
> c.COLUMN_NAME,
> c.DATA_TYPE
> FROM INFORMATION_SCHEMA.TABLES t
> JOIN INFORMATION_SCHEMA.COLUMNS c ON
> c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
> c.TABLE_NAME = t.TABLE_NAME
> WHERE
> c.DATA_TYPE IN('char', 'varchar', 'text') AND
> t.TABLE_TYPE = 'BASE TABLE'
> --list stored procedure and function character parameters not unicode
types[vbcol=seagreen]
> SELECT TOP 10
> SPECIFIC_SCHEMA,
> SPECIFIC_NAME,
> PARAMETER_NAME,
> DATA_TYPE
> FROM INFORMATION_SCHEMA.PARAMETERS
> WHERE
> DATA_TYPE IN('char', 'varchar', 'text')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
> news:u0a4ka52EHA.1292@.TK2MSFTNGP10.phx.gbl...
unicode
>
|||Sierra wrote:
> Hi guys
> Can anyone provide me some checklist to verify that SQL 2000 is
> unicode enabled . In short how do i test the same
> Help is appreciated !
> Regards
> Sierra
You use unicode data by using nchar, nvarchar, and ntext data types in
your tables. If you don't use those data types, you can't store unicode
data.
David Gugick
Imceda Software
www.imceda.com
|||Perhaps I don't fully understand your question but all SQL Server 2000
instances are 'unicode enabled'. One can store unicode data in nchar,
nvarchar or ntext data types.
Hope this helps.
Dan Guzman
SQL Server MVP
"Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
news:%23q3lulO2EHA.3392@.TK2MSFTNGP10.phx.gbl...
> Hi guys
> Can anyone provide me some checklist to verify that SQL 2000 is unicode
> enabled . In short how do i test the same
> Help is appreciated !
> Regards
> Sierra
>