| |

VerySource

 Forgot password?
 Register
Search
VerySource»Forum › Database › MS-SQL Server › How many Chinese characters does the length of the v ...
12Next
Return to list New
View: 1568|Reply: 12

How many Chinese characters does the length of the varchar field equal to 100?

[Copy link]
muxiaoke

2

Threads

6

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China
Post time: 2020-1-4 15:40:01
| Show all posts |Read mode
As the title
Reply

Use magic Report

tutuzhu

0

Threads

2

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 Unknown
Post time: 2020-1-4 15:42:01
| Show all posts
100
Reply

Use magic Report

knightzk

0

Threads

8

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China
Post time: 2020-1-4 16:03:01
| Show all posts
100
Reply

Use magic Report

githzerai

1

Threads

7

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China
Post time: 2020-1-4 16:39:01
| Show all posts
50
Reply

Use magic Report

unkmass

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China
Post time: 2020-1-4 17:12:01
| Show all posts
50
Reply

Use magic Report

walfman000

0

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 Peru
Post time: 2020-1-5 08:24:01
| Show all posts
50
Reply

Use magic Report

caboom04

3

Threads

17

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China
Post time: 2020-1-5 14:51:01
| Show all posts
But the content I entered is about 30 words. If I want to transfer the data to another same table, the characters will be truncated.
Reply

Use magic Report

imapiggy

0

Threads

14

Posts

12.00

Credits

Newbie

Rank: 1

Credits
12.00

 China
Post time: 2020-1-6 11:09:01
| Show all posts
50
Reply

Use magic Report

caoyuezj

1

Threads

15

Posts

7.00

Credits

Newbie

Rank: 1

Credits
7.00

 China
Post time: 2020-1-9 09:18:02
| Show all posts
50
Reply

Use magic Report

yuanweis

0

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China
Post time: 2020-1-9 11:45:01
| Show all posts
50, you can verify it yourself. Try inserting with Chinese characters.
nvarchar100 should be 100 Chinese characters.
Reply

Use magic Report

Next »
12Next
Return to list New
Advanced Mode
B Color Image Link Quote Code Smiles
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