Database character set, how to modify from ANSI to unicode

ajsdhja

Because the word creation program (eudcedit.exe) is used for word creation, the GBK code point is not enough. I want to use unicode code point for word creation. However, some words created by unicode code point can be displayed in the database. Is a question mark.

  For the later parts of unicode code points (i.e. those that exceed GBK code points), the more question marks, now you want to make the database support the display of unicode code points, how to do it is to change the character set of the database

  These later code points can be displayed correctly in txt or word, which is a question mark in the database

  How to modify the character set of the database, in which step to choose the character set support during installation

Please master

yjwfkill

Just got the help of other people in the forum, I also try to answer a question, let’s talk about it.
"How to modify the character set of the database, and at which step to choose the character set support during installation"
1. I remember that it was the last step of dbca, the step of initialization parameters, there is a tab that can be selected in the character sets. According to your requirements, you may need to use AL32UTF8 type.
2. On the issue of modification.
I have tried to use the reconfiguration function of dbca for this problem, but those options are always grayed out and cannot be modified.
Later I learned about the View that displays the setting value:
nls_database_parameters.
－－－－－－－－
select name,
       substr(value$, 1, 40)
from props$
where name like'NLS%'
－－－－－－－－
By displaying all the values ​​you can find: 　　　NLS_NCHAR_CHARACTERSET AL16UTF16
This is the place to set the character format, and then modify the table props$,
update props set value$=’AL32UTF8’ where name=’NLS_NCHAR_CHARACTERSET’

Through the above method, I successfully changed the character format.
I hope useful to you.

liub950511

Set the character set of your Oracle Client to be the same as the character set of Oracle Server, or a subset of the character set of Oracle Server.

It is best not to go to the character set of the Oracle server, because the character set of the Oracle server is determined during installation. If it is modified, unexpected problems may occur.

ajsdhja

I reinstalled the server, I chose ‘AL32UTF8’, the client was 9i character set, and I changed the registry to ‘AL32UTF8’

But manually input the code point of f8e1, it is still a question mark, the field type varchar, nvarchar display the same


How is this going?

Try to use the character creation program, create a character in the code position f8e1, and manually enter it into the database to see if it can succeed

ajsdhja

waiting...