| |

VerySource

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

Database character set problems

[Copy link]

4

Threads

15

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China

Post time: 2020-3-8 14:30: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.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-7-26 23:00:01
| Show all posts
To change the character set of the database, it is too simple, you only need to log in to Oracle as sys, and then: SQL> update props$ set value$='AL32UTF8' where name='NLS_CHARACTERSET';
After SQL> commit;, close it again and restart the database.
Reply

Use magic Report

4

Threads

15

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China

 Author| Post time: 2020-7-31 13:45:02
| Show all posts
I reinstalled the server side of oracle and chose the character set'AL32UTF8', but it is still a question mark, such as the code point f8e1
I entered it manually, the question mark was displayed, and when I copied it from other places, it was displayed correctly.

I also used the zhs16gbk character set, and it is the same.

Why the character set doesn't matter

How can I solve it?
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-22 20:45:01
| Show all posts
UTF-8
Reply

Use magic Report

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

Points Rules

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

Quick Reply To Top Return to the list