Member Avatar for can-mohan

Hi All,
in sqlite SMALLINT datatype is used to store 2 bytes integer but i didn't see any Unsigned SMALLINT type to support the range(0-65535).
Can anybody let me know how to achieve the same.

  • 2 Contributors
  • 1 Reply
  • 159 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

Hi,

try the CHECK() constraint, for example:

CREATE TABLE test (
    number SMALLINT CHECK(number BETWEEN 0 AND 65535)
);

When you try to insert something out of that range, it will raise an error. See also:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.