Collation problems after mysql upgrade

Discussion in 'MySQL' started by ian_ok, Mar 11, 2006.

  1. #1
    the MYsql database version has been upgraded and now if a user logs in add a listing the listing is NOt added

    You can view the d/b all Ok and the end user see no change just admin users/agents can't add listings.

    On the d/b a new column has appeared 'Collation' and then in some of the fields rows it says: latin1_swedish_ci

    I think this is the problem, but I don't know how to get it back to how it was before, it never had collation and I'm unsure what character setting it should be (if any!)

    Any help pointers etc....

    Thanks Ian

    **SOLVED** Was a problem with mising code in htaccess and lchanging the ocation of some other code
     
    ian_ok, Mar 11, 2006 IP