Post reply

Dynamic sql and hebrew

  • June 11, 2009 at 12:21 pm

    #132870

    i am making a temp table with a collation of the db that i work on.

    when i try to insert a row using a dynamic query to this table,

    i see "good ??????" instead of hebrew letters (where the ????)

    ** the column with the hebrew in the emp tabled isdefined as nvarchar(5),and when i pprint the dynamic query of the insert in the query analayzer i see everyting ok.

    any idea?

    thanks

    peleg

  • June 12, 2009 at 10:05 am

    #1008778

    How did you define the temp table? Did you add a collation to the DDL?

  • June 12, 2009 at 11:46 am

    #1008830

    i do this

    SELECT CAST(NULL as NVARCHAR(50)) as Company , CAST(NULL as NVARCHAR(50)) as ServiceName

    INTO #ReportTable

    when i check the COLLATION of the column i see it's :

    SQL_LATIN1_GENERAL_CP1_CI_AS

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

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