Efficient way to store FilePath
<p>Currently I have a table with the following format/Desc:</p>

<pre><code>ColumnName  ColID   PK  IndexPos    Null    DataType
ID          1                   1   N       VARCHAR2 (1 Byte)
FILEPATH    2                       N       VARCHAR2 (127 Byte)
</code></pre>

<p>As you can see the length of ID Column is only 1 Byte we can store only 36 different file paths. I have more than 35 different file paths that has to be stored and retrieved. I know increasing the length of ID solves the issue but I want to also know/suggestion that is there any Efficient way to handle this.</p>

<p>Thanks!</p>