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

Built-in data types case setting not honored for char

Matthew.WilkersonMatthew.Wilkerson Posts: 45
edited May 12, 2008 2:03PM in SQL Prompt Previous Versions
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&lt;SPACE>char<SPACE>(7)

I get:
DECLARE @x CHAR (7)

instead of:
DECLARE @x char (7)

When I type:
declare<SPACE>@x&lt;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&lt;SPACE>as<SPACE>char(7))
or:
select<SPACE>cast(@x&lt;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

Sign In or Register to comment.