I'm pretty sure this is not a SQL Server problem.
I already asked a question HERE with an awesome explanation, BUT I still can't explain to the guys where I work that it has nothing to do with SQL Server collation or etc.
We create scripts ( INSERTS/DELETS ) using ANSI. We send these scripts to our clients. Out clients run these scripts via SQLPLUS, SSMS, or any other method.
When they use something that is using ANSI, there's no problem.
BUT we would like to FORCE soomething, to tell them something like
"hey, you are running this script with a different encode, and some characters will be worngly formated, like an
ã would be
is there a way to force a script to run on it's native encode ( the encode that I created )?
I really have no idea how to dead with this problem. We want to sent a script, and we want to be sure that this script will run with A being A, Ã being Ã.