# Re: non-sprayed table does not support partition ?

**URL:** <https://forum.kx.com/t/re-non-sprayed-table-does-not-support-partition/5634>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [June 10, 2008, 3:42am UTC](https://forum.kx.com/t/re-non-sprayed-table-does-not-support-partition/5634 "2008-06-10T03:42:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![felix1](https://avatars.discourse-cdn.com/v4/letter/f/3e96dc/32.png) [@felix1](https://forum.kx.com/u/felix1)\
**Post date:** [June 10, 2008, 3:42am UTC](https://forum.kx.com/t/re-non-sprayed-table-does-not-support-partition/5634/1 "2008-06-10T03:42:00Z")

</div>

…still, use nested char vector columns or encode the data to long ints if your text is less than 10 or 12 chars.

you can do this with .Q.j10/.Q.j12 and decode with .Q.x10 or .Q.x12.

felix