|
Subject:
|
How to change the length of "Money"
|
|
Posted By:
|
hlchuah77
|
Post Date:
|
11/15/2004 1:24:20 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.
|
|
Reply By:
|
Imar
|
Reply Date:
|
11/15/2004 2:11:31 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?
|
|
Reply By:
|
hlchuah77
|
Reply Date:
|
11/15/2004 3:02:41 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?
|
|
Reply By:
|
Imar
|
Reply Date:
|
11/15/2004 3:16:59 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?
|
|
Reply By:
|
hlchuah77
|
Reply Date:
|
11/16/2004 7:31:40 AM
|
Ya, thank you so much, 
|
