On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote: > I'm wondering if the availability of 128-bit numbers has ever been > contemplated? The reason I'm asking is that I have an application that > needs to store IPv6 addresses, which are 128bits. Right now, I'm > storing them in 2 64-bit fields, but this obviously complicates the > query quite a bit. >
Declare the field as CLOB or TEXT and store the numbers that way. You can store any size number you want in a TEXT column. You just cannot do arithmetic on them if they are bigger than 64 bits. Do you need to do arithmetic on your IPv6 addresses? -- D. Richard Hipp <[EMAIL PROTECTED]>
