us0r
05-07-2008, 10:39 AM
Hi,
I have been banging away at this for a few days now and cant seem to find anything to help me on the net.
I need to be able to use russian characters for names and such in my database so I created a table and set my collation to Cyrillic_General_BIN for each field that needs the chars and "Name" field to nvarchar(100).
when I try to use my asp.net code i get ?????s in the database so I tried to insert manually and it works fine. when I set a variable in the database and try to run it i still get the ?'s so its not a .net thing. for my test I did 2 fields.
here is what I did:
declare @name nvarchar(100)
set @name = 'советских солдат'
insert into profile(Name, City) VALUES (N''+@name+'', N'ких')
(1 row(s) affected)
when I select name field is ?'s and city field is fine:
16 ????????? ?????? ких
can someone please help?
I have been banging away at this for a few days now and cant seem to find anything to help me on the net.
I need to be able to use russian characters for names and such in my database so I created a table and set my collation to Cyrillic_General_BIN for each field that needs the chars and "Name" field to nvarchar(100).
when I try to use my asp.net code i get ?????s in the database so I tried to insert manually and it works fine. when I set a variable in the database and try to run it i still get the ?'s so its not a .net thing. for my test I did 2 fields.
here is what I did:
declare @name nvarchar(100)
set @name = 'советских солдат'
insert into profile(Name, City) VALUES (N''+@name+'', N'ких')
(1 row(s) affected)
when I select name field is ?'s and city field is fine:
16 ????????? ?????? ких
can someone please help?