we are using TOAD 22.214.171.124 for our development. In some or our packages we use N-quoted literals. TOAD however, thinks it’s cute to replace them with its U-quoted counterpart. We have a mechanism in place that generates code scripts and that doesn’t really like this, escpecially the double backslash that appears in some code lines. But the real issue for me personally is that TOAD single-handedly decides to change code I wrote. It should not do that.
CREATE OR REPLACE PROCEDURE mhere2_test IS myvar1 NVARCHAR2 (50); myvar2 NVARCHAR2 (50); BEGIN myvar1 := N'\n'; myvar2 := N'Délégé'; END; /
CREATE OR REPLACE PROCEDURE mhere2_test IS myvar1 NVARCHAR2 (50); myvar2 NVARCHAR2 (50); BEGIN myvar1 := U'\\n'; myvar2 := U'D\00E9l\00E9g\00E9'; END; /
Is this a setting somewhere, or how can we avoid this?
Database NLS_LANG = american_america.al32utf8
Client NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
Since I don’t have privileges on my pc (I have to go through a request procedure) I rather see as little changes on my client as possible.