Hi
I want change house_info Table's column collation to the persian so I wrote below code
ALTER TABLE House_info
ALTER Name NVARCHAR(50) COLLATE Persian_100_CI_AI
I changed it becuse there were some problem in order by becuse when I used order by Name ASC it didn't show data correctly becuse collation was Arabic so I changed it to persain...
when I changed collation, At first it order data correctly But when I insert new data in table again it didn't show data correctly.... it just happen when I insert new data if I don't insert any new data in table it order data correctly....
why this happen?
What should I do for solving this problem?
Best Regards
Neda
