Skip to Content
0
Former Member
Jun 29, 2009 at 12:14 PM

SQL. Inserting of cyrillic (russian) symbols

259 Views

Hi

I need to insert into table Cyrillic symbols.

If they are English everything is OK.

Here is the code

create table qqq (q1 nvarchar(10), q2 nvarchar(30))

declare @cmd nvarchar(300)

set @cmd='insert into qqq values (1,''All'')' +

'select * from qqq'

execute sp_executesql @cmd

drop table qqq

I want to change "All" for "Всего" but get only ??? instead of russian word

in plain query it will be: select N'Всего' instead of select 'All'

but how to do this in this construction

With regards,

Maxim Groonis