Converting string to unicode string in T-SQL

Hi,

We have stored proc name proc_test(str nvarchar(30)). So far this proc
has been invoked from a .NET application assuming that only English
character strings will be passed to it. The calls are like
proc_test('XYZ')
We now have a requirement for passing Chinese strings as well. Rather
than changing the calls throughout the application, we would like to
handle it in the stored procedure so that it treats the string as a
unicode string. Can we apply some function to the parameter to convert
it to unicode so that we don't have to call with an N prefixed to the
string?

Thanks,
Yash

.

Relevant Pages

  • RE: executing sproc
    ... Issue is resolved by adding Initialization string to DSN. ... for the stored proc but not for the SQL statement. ... > establish a new Connection Cnct and open it successfully. ...
    (microsoft.public.data.ado)
  • Re: ExecuteNonQuery() returns -1
    ... affected for INSERT, DELETE and UPDATE statements. ... (presumably including calls to a stored proc) ... CalendarType As String, ByVal StartDate As Date, ByVal EndDate As Date) ... Dim RowsAffected As Integer ...
    (microsoft.public.dotnet.framework.adonet)
  • Truncation of Argument with ADo Components
    ... I have encountered and interesting and frustrating problem with the ADO ... when I pass a string argument which is destined for an image ... column in the DB into a parameterised INSERT query, only the first character ... resorting to using a stored proc. ...
    (borland.public.delphi.database.ado)
  • ExecuteNonQuery() returns -1
    ... I am trying to insert new records in table via stored proc ... There is no exception thorwn but RowsAffected is ... CalendarType As String, ByVal StartDate As Date, ByVal EndDate As Date) ... Dim RowsAffected As Integer ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Passing comma seperated values to a stored proc
    ... I want to pass this string into a Stored Proc and just use an ... > "Syntax error converting the varchar value '123456,123457,123458' to a ... > How would I go about converting the string to an integer and still use the ...
    (microsoft.public.sqlserver.programming)