Issue Details (XML | Word | Printable)

Key: CORE-697
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: joaommp
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Unsigned Integer and Unsigned Quad

Created: 28/Jan/04 12:00 AM   Updated: 14/Jun/06 09:41 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 1.5.0

Time Tracking:
Not Specified

SF_ID: 886189


 Description  « Hide
SFID: 886189#
Submitted By: joaommp

One feature I need is the ability to work with unsigned
Integers and Unsigned Quad (quadword). MySQL, for
example, allows one to define a numeric field as being
unsigned, for both Integer and BigInt. I noticed that
Interbase apparently used to have a QUAD field/data
type, but it is no longer usable in Firebird.
I may be wrong, but for what I can tell, the numeric
data type doesn't allow 64bit unsigned integers.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alice F. Bird added a comment - 14/Jun/06 09:41 AM
Date: 2005-03-23 14:03
Sender: joaommp
Logged In: YES
user_id=650953

NUMERIC(18,0) doesn't give the full width of a 64bit
UNSIGNED int. For that 20 digits are required.

Alice F. Bird added a comment - 14/Jun/06 09:41 AM
Date: 2005-03-23 12:24
Sender: dimitr
Logged In: YES
user_id=61270

BIGINT is a 64-bit signed number, also available via
NUMERIC(18, 0).

Alice F. Bird added a comment - 14/Jun/06 09:41 AM
Date: 2004-01-28 14:15
Sender: joaommp
Logged In: YES
user_id=650953

I forgot to mention that it should be able to be used as a
Primary key, therefore, workaround solutions like array of char
and similar would probably not work.