Some strange problems with database - anyone other faced?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Some strange problems with database - anyone other faced?

    Hello guys,

    I am facing some strange problems working on database!

    One is, wrong displaying of characters. When I created a website in my localhost, i can save non-ASCII characters in database and deal as I want with them, but when I moved the site to a live server, those characters are not displaying as expected.

    Another problem is, I can insert whatever data using the "INSERT" query, but when it comes to "UPDATE" it doesn't work and no error is being showed. Does the characters has to do with this?

    Thanks in advance!
    mysterio.al - programming is a functional art

    #2
    Sounds like you are using the wrong character encoding
    i would try something like:
    PHP Code:
    ALTER TABLE table CHANGE column column TEXT CHARACTER SET utf8
    Added after 4 minutes:

    may be easier to just recreate the tables to utf8.... rather than do it for each column
    Last edited by something else; 01.08.11, 23:20.

    Comment


      #3
      Also try to change the encoding in header
      Did I help you?
      You can help me too
      Your donations will help me finance my studies.

      Comment


        #4
        Thank you guys,
        tried already - no result!

        I note that in local server is everything ok, this happens in live server only where the site is only moved with Filezilla and database imported using SQLYog.
        Does server configurations has to do with it?
        mysterio.al - programming is a functional art

        Comment

        Working...
        X