title: Efficient way to store FilePath
body: <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>