Foreign characters being inserted into the Oracle insert

0

I have an oracle XE database, I want to import scripts into sql to fill tables, however, characters with accents and Ç for example get strange characters for example. In this example insert:

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 query 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

Should I change something to import the sql correctly?

    
asked by anonymous 18.09.2018 / 04:29

0 answers