unicode parameters in stored proc
Hi,
I'm trying to process Asian languages in a stored procedure, but they end up being stored in the database table as gibberish. I know we can use N'unicode_string' and that works fine. But I'm trying to pass a parameter from user input in ASP webpage, and not a literal string within the stored proc. I'm not asking how to pass the parameter back and forth from/to the webpage. Even testing the stored proc with with a parameter passed from QA I get gibberish as a result in the table. Is there something I have to do to the parameter in the stored proc for it to be stored as unicode correctly in the table?
I'm just doing simple inserts and update procedures. Eg, "insert into members (name, ...) values (@name, ...)", "update members set name = @name where ...".
I need that '@name' to be changed into unicode somehow like N'' does for literal strings. All stored procs and tables are set to nvarchar etc.
I've been googling for ages and can't find any answers to this. Only answer I can find is to use N'' for literal strings which doesn't work for a parameter.
Thank you very, very much!
Pete
|
