How to change the length of "Money"

hlchuah77 · November 15th, 2004, 02:24 PM

When I define my data type to "Money", the length 8 is shown automatically. I try to alter the length, but it is alter-disable.

I know "Money" is a data type which its domain fall within
-922,337,203,685,477.5808 to 922,337,203,685,477.5807

So, can any one tell me how the length of 8 can relate to the domain as mentioned above seeming that the length is alter-disable, and is there any way to alter it, if, there is the case.

Imar · November 15th, 2004, 03:11 PM

With Money (and some other datatypes, like DateTime for example), the Length is not the length in number of characters, but in bytes.

SQL Server uses 8 bytes to store a Money datatype, resulting in the number you gave in your post.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: trust by The Cure (Track 8 from the album: Wish) What's This?

hlchuah77 · November 15th, 2004, 04:02 PM

I see... its 8 bytes...

So, it means that there is no way for me to alter the length (because 8 byte is at default), is it?

Imar · November 15th, 2004, 04:16 PM

Yes, AFAIK, that is correct. Money is money.... ;)

Why do you want to limit it??

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Down On The Street by Rage Against The Machine (Track 10 from the album: Renegades) What's This?

hlchuah77 · November 16th, 2004, 08:31 AM

Ya, thank you so much,