Issue in DB installer with Spanish language Script

[ramit]

Hi Cosmin,

I have created a database installer and I am running SQL Script to insert master data.
My SQL Script containing master data which is in Spanish (Chile) language, now I facing once issue
If I run that script file directly from SQL Server it is working fine however if I run the same Script file from DB installer it is converting following character to some other characters
“ áéíóúÁÉÍÓÚüÜñѺ “

I am not getting how to solve this. Do you have any idea?

Please help.

Thanks,
Amit Rajput

[GabrielBarbu]

Hello,

Can you please tell us what encoding are you using for your SQL Script? Also, what version of Advanced Installer are you using?

Thank you,
Gabriel

[ramit]

Hi Gabriel,

I am using 6.3 version.
I was using Encoding "ANSI", now I changed it to "Unicode" now it is working fine.


Thanks.