Re: User Defined Data Types Problem
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 8 Jul 2006 17:21:27 +0000 (UTC)
royaldothighness@xxxxxxxxxxx (royaldothighness@xxxxxxxxxxx) writes:
I defined unsigned_int in my database, which uses unsigned_int_range
rule. The unsigned_int_range rule is defined as follows:
@unsigned_int >=0 and @unsigned_int <=4294967295
(4294967295 = 0xFFFFFFFF)
The storage size is 4 bytes.
One of the tables in the database contains a field that is of type
unsigned_int.
When I try to add a new record into the table (ex: using the Enterprise
Manager), it always fails in the unsigned_int field if I enter a value
greater than 2147483647 (which is 0x7FFFFFFF) all the way to 4294967295
(0xFFFFFFFF). The Enterprise Manager shows the following message:
"The value you entered is not consistent with the data type or
length of the column, or over grid buffer limit."
What is wrong here? The 4-byte storage should be good for any value
from 0 to 4294967295.
Since you mention Enterprise Manager, I assume that you use SQL 2000.
To define a user-defined data type with that range you would have to
to base it on bigint or decimal(10, 0). You cannot use int as a base,
since int is signed.
In SQL 2005, you could define your unsigned int throught the CLR, although
I doubt that it would be worth the pain.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- User Defined Data Types Problem
- From: royaldothighness@xxxxxxxxxxx
- User Defined Data Types Problem
- Prev by Date: User Defined Data Types Problem
- Next by Date: Re: User Defined Data Types Problem
- Previous by thread: User Defined Data Types Problem
- Next by thread: Re: User Defined Data Types Problem
- Index(es):
Relevant Pages
|
