Re: char array overhead

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 03/31/2014 09:48 AM, Steve Atkins wrote:

On Mar 31, 2014, at 8:08 AM, Rob Sargent <robjsargent@xxxxxxxxx> wrote:

I'm angling toward using a very wide char(1) array.  Is the one-byte overhead for char(n<126) applied to each element or to the array?

Each element, it's a variable length type.

There's probably a better way of storing your data, but if you end up really needing a one-byte long character type, there is "char" (with the quotes).

Cheers,
  Steve

Thank you! First for the confirmation on the overhead (how disappointing) and secondly for the "char".  That had not crossed my radar.

Jsyk, I'm toying with a rather large number of small valued datapoints per sample.  I'm tying text and smallint as well.

Thanks again,

rjs