0
I have an oracle XE database, I want to import sql scripts to fill the tables, however, characters with accent and Ç for example get strange characters for example. In this example Index:
Insert into PESSOA   (ID, TIPO, CPF_CNPJ, RAZAO_SOCIAL,      
        NOME_FANTASIA, RG_INSC_ESTADUAL, LOGRADOURO, 
        NUMERO, CEP, BAIRRO, NOME_CONTATO, TELEFONE_1,
        TELEFONE_2, EMAIL, CIDADE_ID) 
Values    
        (170, 'J', '12010779000105', 'MOTO BOX PEÇAS E
         ACESSÓRIOS LTDA', 'MOTO BOX',  '040000052 ', 
        'RUA VISCONDE DE NHAUMA', '315', 
        '55012010', 'MAURICIO DE NASSAU', 
        'CÉLIO', '(81) 3723-0455', '(81) 3721- 5571',
        '[email protected]', 1509);
When I look up the default character types I get the following return:
SELECT value$ FROM sys.props$ WHERE name = 'NLS_NCHAR_CHARACTERSET';  
Resultado =  AL16UTF16
SELECT value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';
AL32UTF8
I must change something to properly import sql?
https://answall.com/questions/69300/
– NoobSaibot
Took my doubts, obg
– Gleyson Silva
Possible duplicate of Insert with accents in Oracle
– João Martins