| |

VerySource

 Forgot password?
 Register
Search
View: 823|Reply: 7

Problems with the SQLserver character set

[Copy link]

4

Threads

15

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China

Post time: 2020-3-8 16: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

2

Threads

18

Posts

16.00

Credits

Newbie

Rank: 1

Credits
16.00

 China

Post time: 2020-5-28 22:00:02
| Show all posts
Reply

Use magic Report

2

Threads

18

Posts

16.00

Credits

Newbie

Rank: 1

Credits
16.00

 China

Post time: 2020-5-28 22:15:01
| Show all posts
nchar and nvarchar
It's unicode
Reply

Use magic Report

4

Threads

15

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China

 Author| Post time: 2020-6-6 09:00:01
| Show all posts
I mean, the unicode characters are manually entered in the database, and the question mark or something is displayed.
Its incorrect

And when the program code is read, it is also a question mark
Reply

Use magic Report

0

Threads

20

Posts

19.00

Credits

Newbie

Rank: 1

Credits
19.00

 China

Post time: 2020-6-12 18:45:01
| Show all posts
Self-made words can only be used on your own machine, there will be problems
Using the unicode characters of the system, some of the sqlserver cannot be displayed normally, but it can still be displayed normally in front of the front end that supports these characters
Reply

Use magic Report

4

Threads

15

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China

 Author| Post time: 2020-6-14 11:30:01
| Show all posts
How to modify sql server, supported character set, change it from ANSI to unicode

"Unicode's own words" are some uncommon words that I created using unicode's spare code points,
I want to store it in the database and save it.

Now the database does not recognize the words I have made, it displays question marks,
So I want to modify it.
Reply

Use magic Report

0

Threads

20

Posts

19.00

Credits

Newbie

Rank: 1

Credits
19.00

 China

Post time: 2020-7-9 00:15:01
| Show all posts
sqlserver originally supports unicode
Reply

Use magic Report

4

Threads

15

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China

 Author| Post time: 2020-7-31 14:15:01
| Show all posts
It turned out to be a problem of field type
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