WVARCHAR column into a VARCHAR

[xch2005]

Hello,

I have a parallel job that executes a SQL Server stored procedure as source and it returns an output of few columns. One of the columns is STATUS which is hardcoded (data type is varchar)in the procedure and that is returned but when the job is run got the following warning. The target data type for this column is also varchar.

Warning:
Writing the WVARCHAR column STATUS into a VARCHAR database column can cause data loss or corruption due to character set conversions
The length of WVARCHAR column STATUS cannot be validated because the database column is VARCHAR and character set conversion is invo
lved. Inadequate column lengths can lead to data truncation or unexpected errors.

Please suggest if there any workaround to fix this warning other than turning this warning into informational.

Thanks in advance.

[kvshrao]

Make sure you that - you haven't enabled Unicode and Specify the length of column



Thanks
Rao Kuntamukkala
www.networkzindia.com