Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unsigned Integer and Unsigned Quad [CORE697] #1066

Closed
firebird-automations opened this issue Jan 28, 2004 · 4 comments
Closed

Unsigned Integer and Unsigned Quad [CORE697] #1066

firebird-automations opened this issue Jan 28, 2004 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: joaommp (joaommp)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

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).

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10721 ] => Firebird [ 15060 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant