In one of our database developers found an issue with data.
The data is 4Ｆ which is returned correctly when using this value and the same is returned when given 4F. That is the symbol is replaced with 'F'. have to give N' (unicode) while searching with both the symbol and F.
Any idea why this happens. The column data type is NVARCHAR.
Thanks in Advance