SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    Nov 2004
    Location
    Canada
    Posts
    373
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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?

  2. #2
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    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?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •