Multi-lang, Dynamic Table And SP Problem

Hello all,

I got a problem with Multi language when it comes to Dynamic Tables in Store procedures.

If I do the following :


SET @StringTableName = N'System_Strings'
SET @StringID = N'100'
SET @LanguageID = N'2'
SET @StringText = N'أثممخ ًخقمي'
SET @Mandatory = N'0'

EXEC (N'INSERT ' + @StringTableName + N' (StringID, LanguageID, StringText, Mandatory) VALUES(''' + @StringID + ''', ''' + @LanguageID + ''', ''' + @StringText + ''', ''' + @Mandatory +''')')


The StringText column shows up as ????????? in the Db.

However if I do the following:


INSERT System_Strings (StringID, LanguageID, StringText, Mandatory) VALUES(@StringID, @LanguageID, @StringText, @Mandatory)


The StringText column shows with the correct Arabic text.

Does anybody know how to use Dynamic Tables aswell as Multi Language?

Best Wishes,
Farek