What are the challenges you face when working across database platforms? Take the survey
Options

A bug about the length of the byte

zhiyounetzhiyounet Posts: 10 New member
edited September 19, 2017 2:48AM in SQL Prompt
After formatting, parentheses are not aligned:
insert into 测试表名 (
a
,b
,c
)
values ( 'a', 'b', 'c' );

insert into test (
a
,b
,c
)
values ( 'a', 'b', 'c' );

When the table name is a double-byte character, the length calculation is incorrect. A bit like excel function, len () and lenb () the difference.
9nfeif4l134u.png

Tagged:

Comments

Sign In or Register to comment.