Simple Invoices logo
HOME | DOWNLOAD | BLOG | FORUM | DEMO
Not signed in (Sign In)

Support: data entered turns into garbage

Bottom of Page

1 to 8 of 8

  1.  
    • CommentAuthorVeGaTrOn
    • CommentTimeDec 14th 2009
     permalink
    hi

    UTF-8 is it really working in SimpleInvoices??

    I have a problem , whenever I add new Item/customer ... the data turns into garbage
    as seen in the images,, the posted form data doesn't seem to be stored as utf-8 ,





    • CommentAuthorjustin
    • CommentTimeDec 14th 2009
     permalink
    Hey VeGaTrOn

    refer: http://simpleinvoices.org/config#ini

    set database.utf8 = false

    and retest

    let us know how it goes

    Cheers

    JustinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorVeGaTrOn
    • CommentTimeDec 16th 2009
     permalink
    hey justin

    I tried it, it didnt work..
    • CommentAuthorjustin
    • CommentTimeDec 17th 2009
     permalink
    hey VeGaTrOn,

    can you try using our demo site: http://simpleinvoices.org/demo/

    add some products and see if they appear OK - i've tried in russian script and it seems OK

    note: the demo site gets refreshed each hour

    cheers

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorVeGaTrOn
    • CommentTimeDec 20th 2009
     permalink
    !!!

    on the demo site it works well.. but locally it won't

    ?? any other ideas
    • CommentAuthorVeGaTrOn
    • CommentTimeDec 20th 2009
     permalink
    FINALLY!!!!!!!!!!!!!
    Problem solved,, oh yeaaaaaaaaaaah

    at the : include/sql_queries.php

    I made the default "case" for the "switch" is the "mysql_utf8" case

    by copying it over the "mysql" case
    • CommentAuthorVeGaTrOn
    • CommentTimeDec 21st 2009 edited
     permalink
    hi
    I was wrong about the solution... I did solve the problem but another way

    I tried doing the same "solution" on my laptop ,but it didn't work,, I did another thing that made it work

    phpmyadmin->simpleinvoices DB -> operation -> Collation: unicode_utf8_ci -> GO

    this will do the trick..
    although I created the DB as a unicode_utf8_ci ,, but for some reason doing this made it work


    hope this helps anyone who had the same problem
    • CommentAuthorjustin
    • CommentTimeDec 24th 2009
     permalink
    thanks for posting this

    Question: do you know the encoding of the tables pre setting them to unicode_utf8_ci ?

    all tables should be set to unicode_utf8_ci by default in Simple Invoices .sql files - but i can;t guarantee how all the different version of MySQL import our .sql files

    Cheers

    JustinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me

1 to 8 of 8

  1.