NVarchar Vs Varchar and Varchar Unicode

[mab_arif16]

Hi
I am joining data on a feild which is of varchar unicode type .When I convert the feild to Nvarchar type I get a different output than when joined on varchar and varchar unicode types.
What if the difference between these data types when used as joined key
is NVarchar similar to Varchar with unicode option.
thanks
Arif

[kris007]

I am not quite sure what the Unicode means but IBM folks up here donot encourage to use that unicode in your table definition.