[varchar] (100) and empty space

[anselme]

Hello

I am creating the following table

CREATE TABLE [dbo].[myT] (
[name] [varchar] (100) NULL
)


if I do

INSERT INTO myT (name) VALUES ('A')

i get in the table a column with

A ...

the 100 char place is full even if there is a data with only 1 char

how is it possible to avoid it ?
I want 100 char maximum but not full with nothing


thank you for helping

[rmiao]

On which rdbms? How do you know it uses 100 bytes?

[MAK]

run this command

select datalength(name) from myT

[anselme]

I am getting 200
2 time the normal size !

[MAK]

r u sure you are querying the right table?
This is what i got

CREATE TABLE [dbo].[myT] ([name] [varchar] (100) NULL )

INSERT INTO myT (name) VALUES ('A')

select datalength(name) from myT
--result 1

[anselme]

sorry ! that field is nvarchar and I get 200 for [name] [nvarchar] (100) NULL

if i run the code

CREATE TABLE [dbo].[myT] ([name] [varchar] (100) NULL )

INSERT INTO myT (name) VALUES ('A')

select datalength(name) from myT

i get also 1

but I don't understand from where are coming in my table the blanks char
each column = any(----------long space-------)

the datalength allways= 100

[rmiao]

Double check your table schema and how inserted values.

[anselme]

I have inserted values with a @parameter char(100) !

:-(

now it works
thank you