character set mismatch error while using cast function in IDT

[Former Member]

Hi ,

Could you please help on this issue . I am trying to use the cast function to convert number varchar in Information design tool .

But it is throwing error message character set mismatch.

Thanks & Regards

Venkat

[former_member184594]

What is you syntax? Could you share it so that we may help you better?

[Former Member]

Hi ,

I am using correct syntax and its parsing correctly at universe level but while trying to see the value its throwing character mismatch error .

At table level the column (column name as version name) data type is nvarchar . It contains the value like V0 , xyz, abc .. etc. I need display 000 instead of V0 value .

so I am using the below code to convert V0 to 000

case when version='V0' then cast('000' as varchar) else version end .

Thanks

Venkat

[Former Member]

Make sure ou set the datatype of the object as Char before converting it

[Sujit]

Are you using multiple objects / columns in the expression, in that case you will have to CAST the other related columns too, else there will be a mismatch in the datatype hence the error.

Let me know if this helps.

Sujit