We are trying to run a DTS for a database that has a table in it that contains japanese characters in a unicode column. When we run a select against this column, we show no data in the database where the data was DTS's to -- but we do see data in the original table. Is there a setting I am missing to get this data over? We are running SQL Server 2000 sp4.

Here is the table structure (the lost data is in the verbatim column)

CREATE TABLE [dbo].[Verbatims]
[VerbatimID] [int] IDENTITY (1, 1) NOT NULL
[CaseID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
[ORGCode] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
[WAVCode] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
[ATTCode] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
[STDCode] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
[GEOCode] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
[Verbatim] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY
G

CREATE CLUSTERED INDEX [IX_Selections] ON [dbo].[Verbatims]([STDCode], [ORGCode], [WAVCode], [ATTCode]) ON [PRIMARY
G

ALTER TABLE [dbo].[Verbatims] WITH NOCHECK ADD
CONSTRAINT [PK_Verbatims] PRIMARY KEY NONCLUSTERED

[VerbatimID
) ON [PRIMARY]
G

if (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) <> 1
exec sp_fulltext_database N'enable'

G

if not exists (select * from dbo.sysfulltextcatalogs where name = N'VerbatimSearch'
exec sp_fulltext_catalog N'VerbatimSearch', N'create'

G

exec sp_fulltext_table N'[dbo].[Verbatims]', N'create', N'VerbatimSearch', N'PK_Verbatims
G

exec sp_fulltext_column N'[dbo].[Verbatims]', N'Verbatim', N'add', 1041
G

exec sp_fulltext_table N'[dbo].[Verbatims]', N'activate'
G

On the target server, set the collation to Japanese-unicode

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***