How to store file paths on phpmyadmin?
<p>I am using <code>XAMPP</code> and I want to store image paths on my <code>phpmyadmin</code> database and I saw here: <a href="https://stackoverflow.com/questions/4377740/database-design-preferred-field-length-for-file-paths">Database design : preferred field length for file paths</a> that the best options to store file paths should be <code>VARCHAR(MAX)</code> or <code>NVARCHAR(MAX)</code>.</p>

<p>As I cannot set <code>VARCHAR(MAX)</code> or <code>NVARCHAR(MAX)</code> on my <code>phpmyadmin</code>, </p>

<p>How can I store these paths on my database properly? I mean, what is the best option to store them on my database?</p>

<p><strong>Edit:</strong> I have seen the question that has been marked as possible duplicate. I know that I can "simulate" the <code>VARCHAR(MAX)</code> on <code>phpmyadmin</code> but, as it does not exist by default, it would be better to use another length instead of <code>MAX</code>? </p>

<p>I think that if you set a path of length 100 and you have your <code>MAX</code> as the limit is not worth so <code>VARCHAR(suitable number)</code> would be better than <code>VARCHAR(MAX)</code> (or at least I think it would be better). I am new with <code>MySQL</code> so I do not know about the entrails of it (by the moment). </p>

<p>I think it can be problems of performance or maybe memory but I cannot find anything on the official documentation so please if you find something related post here.</p>

<p>Is there a suitable length for store paths on phpmyadmin? A number of length that it is usually used (and why).</p>

<p>Thanks in advance!</p>