I have the arabic text in the insert statement its insert ????? or some wired characters through WIX SqlScript
<sql:SqlScript Id='Insertion1' BinaryKey='Insertion' Sequence='3' ExecuteOnInstall='yes' ContinueOnError='yes' />
this is the command i have for the insertion like
INSERT INTO [dbo].[Location]([Id],[LocationDesc],[LocationDesc_AR],[LocationTypeID],[FullLocationDesc_AR],[CreateDate],[UpdatedDate],[CreatedBy])VALUES(566,'Al Souq JTC',N'السوق','1',N'تقاطع السوق','4/21/2014 12:42:51 PM','4/21/2014 12:43:24 PM','')
when i run normally its working fine but through wix its not insert properly.
Please help me