Hi,
We have special characters in a file (attached in .zip).
Dev. Studio cannot deploy it, saying:
First error location is highlighted.
On the other hand PL/SQL Developer has no problem with it when deploying.
Also standard deployment/delivery procedure gives us no error for this.
The file is already in UTF-8, according to for instance, Notepad++.
Dev Studio version is in the picture.
What should we do to be able to deploy it from Dev., Studio?
Best answer by jasahu
Hi
The Unicode database character set AL32UTF8 is the recommended database character set for IFS Applications.
Pls refer to following links on how you should use ASCII characters in IFS applictions
The example below shows how to write the Swedish word "LEVERANTÖRSFAKTURA" as a string where the Swedish character "Ö" is above ASCII 127.
DECLARE string_ VARCHAR2(100);BEGIN string_ := 'LEVERANT'||UNISTR('\00D6')||'RSFAKTURA';-- or-- string_ := UNISTR('LEVERANT\00D6RSFAKTURA');END; The example below shows how to use ASCIISTR to find which hex code to use in UNISTR:
SELECT asciistr('Ö') FROM dual;ASCIISTR('Ö')-------------\00D6
/Harshini
Thanks
+13Hi
The Unicode database character set AL32UTF8 is the recommended database character set for IFS Applications.
Pls refer to following links on how you should use ASCII characters in IFS applictions
The example below shows how to write the Swedish word "LEVERANTÖRSFAKTURA" as a string where the Swedish character "Ö" is above ASCII 127.
DECLARE string_ VARCHAR2(100);BEGIN string_ := 'LEVERANT'||UNISTR('\00D6')||'RSFAKTURA';-- or-- string_ := UNISTR('LEVERANT\00D6RSFAKTURA');END;The example below shows how to use ASCIISTR to find which hex code to use in UNISTR:
SELECT asciistr('Ö') FROM dual;ASCIISTR('Ö')-------------\00D6
/Harshini
Hi
The Unicode database character set AL32UTF8 is the recommended database character set for IFS Applications.
Pls refer to following links on how you should use ASCII characters in IFS applictions
The example below shows how to write the Swedish word "LEVERANTÖRSFAKTURA" as a string where the Swedish character "Ö" is above ASCII 127.
DECLARE string_ VARCHAR2(100);BEGIN string_ := 'LEVERANT'||UNISTR('\00D6')||'RSFAKTURA';-- or-- string_ := UNISTR('LEVERANT\00D6RSFAKTURA');END; The example below shows how to use ASCIISTR to find which hex code to use in UNISTR:
SELECT asciistr('Ö') FROM dual;ASCIISTR('Ö')-------------\00D6
/Harshini
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.