MS SQL Server Plugin - Arabic characters

[alimohti]

Hello All,
Am using the MS SQL Server Plugin to execute scripts to my 2008 SQL Server, everything works fine until i use this plugin to insert records with arabic characters in the database, the plugin seems to change the file encoding or doesn't support unicode characters, please advise

[giaviv]

Hi,

What exactly happens? Are you getting an error?

Thanks!

[alimohti]

No it doesn't report any error, but when i check the database after the installation the arabic characters are replaced with either question marks or with unknown character

i tried both ways to execute the script from a file, or by writing the script into the SQL Plugin, and both gives the same result

[giaviv]

Have you tested the script by running it NOT from InstallAware? Does that work at all?

[alimohti]

Yes i did, i created a small console application that reads the SQL file and execute it and everything works fine, but using the SQL Plugin fails.. i don't know how the plugin was written but maybe it reads the file and override the current Encoding which will ruin the Arabic characters, please advise

[giaviv]

Hi,

This is likely happening because unicode is not supported in that plugin.
As a workaround, I would advise trying to invoke command line tools to run the script using the Run Program command.

[alimohti]

this is what i did for the mean while, i created a .net console application execute the SQL script for me... thanks for the support and i hope there would be a newer versions of the plugin that supports unicode characters

[giaviv]

Thank you for your input alimohti.