Post reply

Retrieve Unicode String

  • August 18, 2009 at 5:41 am

    #213685

    Hi All,

    Can any one suggest how to retrieve column value of type nvarchar?

    I have a text box where I type the name in "French" and I have saved the informations in the db with the columns date type as "NVARCHAR" now I need to fetch the respective records from the database by passing the name as Input parameter to a SP. When I execute the SP the respective data is not getting fetched.

    Anyone help me out in this issue.

    Regards,

    CHAKS.

  • August 18, 2009 at 5:45 am

    #1040755

    Are you assigning the result set to a varchar or a nvarchar, if you are assigning to a nvarchar then the output must be there, else check the entry point, when inserting to a nvarchar datatype, preceede the string with N

    Insert into table1 (text) values (N'SampleUnicodetext')

    Hope this helps 🙂

  • August 18, 2009 at 5:52 am

    #1040757

    Hi,

    Thanks for the reply.

    My inserting of data works. I need to retrieve the data for the user name typed in the text box.

    alter procedure up_SearchUser

    (

    @IC_NAME nvarchar(50)

    )

    as

    begin

    select * from tablename

    where [name] = @IC_NAME

    end

    The above SP does not return any result.

    Also when I tool the execute query from profiler it is displayed as the below.

    exec up_SearchUser N'????????????'

    let me know how to proceed.

    Regards,

    CHAKS.

  • August 19, 2009 at 7:04 pm

    #1041915

    Seems to be a permission issue

    MJ

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply