| |

VerySource

 Forgot password?
 Register
Search
View: 10|Reply: 3

Database character set, how to modify from ANSI to unicode

[Copy link]

4

Threads

11

Posts

9

Credits

Newbie

Rank: 1

Credits
9

 China

Post time: 2020-3-15 23:00:01
| Show all posts |Read mode
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
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 Asia/Pacific Region

Post time: 7 day(s) ago
| Show all posts
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.
Reply

Use magic Report

0

Threads

13

Posts

13

Credits

Newbie

Rank: 1

Credits
13

 China

Post time: 6 day(s) ago
| Show all posts
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.
Reply

Use magic Report

4

Threads

11

Posts

9

Credits

Newbie

Rank: 1

Credits
9

 China

 Author| Post time: 6 day(s) ago
| Show all posts
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
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list