SQL Server 2008 column collation -

SQL Server 2008 column collation -

i inserting info tables using dynamic sql:

set @profiles = n'select ''' + @var1 + ''' col1, col2, col3, col4, col5, col6, col7 ' + @tablename + 'tbl1' insert table (col1, col2, col3, col4, col5, col6, col7) exec (@profiles)

above query in stored procedure, run job.

i noticed when job running info japanese characters inserted when job completed , create select on inserted table returns '?' instead of japanese characters. using collation sql_latin1_general_cp1_ci_as , column info type nvarchar. tried alter collation japanese collation returns '?'. know how can handle this?

edit 1 forgot add together stored procedure resides in ssis package. maybe can help.

i found wrong. have function @ lastly step of ssis bundle removes non-printable white characters , function parameter varchar instead of nvarchar. changed nvarchar , ok now.

sql sql-server-2008 collation