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?