I'm having a problem inserting a value into a varchar datatype field,
the value I'm trying to update a value in a column top 'vič' but when its updated it removes the accent above the c however in the same column there is a value š and the s retains its accent.
Can anyone explain why, I know I can convert the column to nvarchar and this will sort the problem but i'm confused why one is accepted the other isn't.
Also if I convert a Varchar datatype column to nvarchar would that alter any of the text at all. :-)