Built-in data types case setting not honored for char
Matthew.Wilkerson
Posts: 45
The built-in data types case setting lowercase is not honored for char data types.
It happens when I press spacebar instead of tab after typing the data type in declaring variables (which I seem to do often, accidentally), or all the time in CAST syntax. The only completion key I have set is tab. The data types varchar and int do not seem to have the problems.
EXAMPLE:
When I type:
declare<SPACE>@x<SPACE>char<SPACE>(7)
I get:
DECLARE @x CHAR (7)
instead of:
DECLARE @x char (7)
When I type:
declare<SPACE>@x<SPACE>char<TAB>7
I correctly get:
DECLARE @x char(7)
It also happens incorrectly in the CAST syntax:
EXAMPLE:
When I type:
select<SPACE>cast(@x<SPACE>as<SPACE>char(7))
or:
select<SPACE>cast(@x<SPACE>as<SPACE>char<TAB>7<RIGHT ARROW>)
I get:
SELECT CAST(@x AS CHAR(7))
instead of:
SELECT CAST(@x AS char(7))
It happens when I press spacebar instead of tab after typing the data type in declaring variables (which I seem to do often, accidentally), or all the time in CAST syntax. The only completion key I have set is tab. The data types varchar and int do not seem to have the problems.
EXAMPLE:
When I type:
declare<SPACE>@x<SPACE>char<SPACE>(7)
I get:
DECLARE @x CHAR (7)
instead of:
DECLARE @x char (7)
When I type:
declare<SPACE>@x<SPACE>char<TAB>7
I correctly get:
DECLARE @x char(7)
It also happens incorrectly in the CAST syntax:
EXAMPLE:
When I type:
select<SPACE>cast(@x<SPACE>as<SPACE>char(7))
or:
select<SPACE>cast(@x<SPACE>as<SPACE>char<TAB>7<RIGHT ARROW>)
I get:
SELECT CAST(@x AS CHAR(7))
instead of:
SELECT CAST(@x AS char(7))
Comments
Many Thanks.
Red Gate Software