govind.sharma (4/18/2008)
When I Change the DataType from CHar To Nchar, Problem is Solved, but I want to Know What is the Impact of Jap_CI_AS on The Databasebecause it work fine with Second Database have Latin1_General_CI_AS.
with Char DataType
It affects string comparison, sorting, and the how it is displayed to the user. When you change to nchar your strings will use twice as much space (nchar is using UCS2 encoding, so it will use two bytes per character, instead of one like char datatypes). You can read more on http://msdn2.microsoft.com/en-us/library/ms187582.aspx
When changing the collation, problems usually arise when you have indexes on these columns, and you do ordering on them using another collation.
Regards,
Andras