Re: Which field to use


Allen Browne wrote:
An IP address is a 4-byte numeric value. It is not a string, even if it is
commonly displayed as discrete bytes in decimal format and separated by
dots. And limiting the characters to digits does not yield adequate
validation.

I stand corrected :)

I've only ever used an IP address as a text item, therefore it made
sense to me it store it how it was 'used'. Of course, I wouldn't store
a DATETIME value as text, though...

Thanks,
Jamie.

--

.

Relevant Pages

  • Re: bigint queston C++ classes
    ... I suggest an array of unsigned char, or unsigned short, or perhaps unsigned ... You'll need ceil/log) base-b digits to store x, ... these are not strings, ...
    (comp.programming)
  • Re: bigint queston C++ classes
    ... I suggest an array of unsigned char, or unsigned short, or perhaps unsigned ... routine for turning the end result into base ten for display, ... You'll need ceil/log) base-b digits to store x, ...
    (comp.programming)
  • Re: receipt of form values by an HTML page
    ... There's a difference between failing a validation check due to ... I'd be inclined to store that pointer in a hidden field rather ... on the client: less load on the database (if indeed there's a database ...
    (comp.infosystems.www.authoring.html)
  • Re: Parse current IP address into environment variables
    ... environment variable called Store based on its value, ... running your script. ... on the MAC address rather than the last two digits of the last octet of the ...
    (microsoft.public.scripting.vbscript)
  • Re: Fibonacci numbers
    ... | Of course there is the question of how to store the number. ... Instead of using characters to represent decimal digits, ... It is easier than dealing with characters, as you don't need to offset ... the way that we write numbers in strings. ...
    (comp.lang.cpp)