Strange characters being inserted into the Oracle Insert

Asked

Viewed 329 times

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?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.