I have a SQL Server 2008 database and I tried inserting this:
insert into MYTABLE
(MY_ID, MY_NAME, MY_NAME_N)
(25, 'Zledzie w [mietanie RosóB', 'Zledzie w [mietanie RosóB')
I am using the first MY_NAME as varchar and second MY_NAME_N as nvarchar. When I do a select * I don't see the polish characters. I am trying this as a test to fix something bigger. I am not sure if its the editor with SQL Management Studio or if its really stored correct.