We are creating scripts to sent to our customers, with some inserts. We save them with ANSI encoding on NOTEPAD++, but when the customer runs the script via SQL*PLUS, it looks like this:
How can I be sure that the customer will run the script, with ansi encode, so we have no problems with those symbols on â, ó and et.
We told them to customize their environment to use NSL_LANG = WE8MSWIN1252. TEST QUERY:
Select *, Case When Teste_CHAR=Teste_CHAR_ASCII Then 'OK' Else 'Erro' END as STATUS_TESTE, Case When Teste_CHAR=Teste_CHAR_ASCII Then 'Everything is OK' Else 'Script will not run. your encode is different from ours' END as Mensagem_TESTE from ( Select CHAR(ASCII('ã')) As Teste_CHAR, CHAR(227) as Teste_CHAR_ASCII ) A
as said here ( **How to be sure that a SQL Script is running with ANSI encoding? ) **this is not correct. But, is there a way to use something like this?