SQL Server - Column Length

Forum|Forum|18 years ago
September 4, 2007
2 replies
421 views

Hi,

When creating a table, and specifying the length of the datatype. Is this determined by the number of charactors or size in bytes?

Is there anyway to configure it to determine the size by bytes?

Thanks

Database access

This topic has been closed for replies.

M

MattasticAuthor

Inspiring

Thanks for your reply.

I dont quite understand that, could you please explain a bit more?

So If I used the ntext datatype it would store the data by memory taken up? Other wise it stores the data using charator length?

P

paross1

Participating Frequently

From BOL....

ntext

Variable-length Unicode data with a maximum length of 230 - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered.

Phil

A

Anonymous

For string data, it's bytes. For the various numeric types, the length is defined by the numeric type (tinyint, int, float, etc.)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded