Cant set desired values in column.. (ex. 1.jpg)

[tdob]

Hey Everyone,

On my personal test server I have a MySQL Datatabase, and one of the fields is a type VarChar(45). For this column I have the default value set as 0.jpg.

Now, on the server provided to me on the internet I cannot select VarChar(45), and all of the ones I have tried only allow me to enter in 0 as thhe default value.

This is a problem as I need to store the filename in this column, ex 1.jpg, 2.jpg, etc.. etc..

Does anyone know a way around this, or what other MySQL columns accept these kinds of values?

[Hartmann]

First, make sure you are using sinigle quotes around the default value.

Second, what table type are you using on your local machine and on the remote host?