A bug about the length of the byte
zhiyounet
Posts: 10 New member
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.
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.
Tagged:
Comments
Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6653) to track it.
Best regards,
Krzysztof
Thanks for your patience!
We have reviewed the bug you reported SP-6653 and unfortunately it is not going to be fixed in near future.
At the moment SQL Prompt do not support localisation/globalisation in our products.
Apologies for the inconvenience caused.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com