Database changing accent by "?"

Question

Database changing accent by "?"

Navigation

#1 by (1 votes)

1

In my PL / SQL all accents are being replaced by "?".

Example of a comment from a table:

Flag of legal device to be ???? used in the term of business or not. Possible values: 1 - Yes or 0 - No. Default: 1

When I create a table directly on it, the accent works, but when I copy a script from a text block for example and paste it into PL / SQL and I create the tables, it stays that way.

How to fix this?

oracle pl-sql

asked by anonymous 01.11.2018 / 14:52

1 answer

Program Creation in Python 3 Pass pointer from sql.DB as method parameter

score 1 · Answer 1

As I suggested in the comments, you can use this query to see your Oracle DB settings:

SELECT * FROM NLS_DATABASE_PARAMETERS;

Your bank has the settings:

NLS_CHARACTERSET: WE8MSWIN1252
NLS_LANGUAGE: AMERICAN

Probably just changing the NLS_CHARACTERSET from WE8MSWIN1252 to WE8ISO8859P1 will solve the problem.

I found the following command to change it:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET WE8ISO8859P1;
SHUTDOWN IMMEDIATE;
STARTUP;

But care , making this change can corrupt your DB data.

Here are some links to see:

link