Post reply

Using Double byte characters in the Management Studio

  • May 19, 2008 at 5:06 pm

    #154368

    I am trying to run a dynamic query with double byte characters as below:

    exec('select 顧客 from yc1')

    When I run this it replaces the double bytes with question marks (??)

    When I run the statement directly it works fine.

    select 顧客 from yc1;

    Any help would be greatly appreciated

    Kris

  • May 19, 2008 at 6:16 pm

    #817531

    kristian aspelin (5/19/2008)

    I am trying to run a dynamic query with double byte characters as below:

    exec('select ?? from yc1')

    When I run this it replaces the double bytes with question marks (??)

    When I run the statement directly it works fine.

    select ?? from yc1;

    Any help would be greatly appreciated

    Kris

    TRy casting the Exec statement to Nvarchar. As in -

    exec(N'select ?? from yc1')

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • May 19, 2008 at 6:32 pm

    #817533

    Thanks Matt,

    That worked:)

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

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