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