SOLVED: problem with umlauts in customer name
  • ezbillingezbilling February 7

    I can't get a grip on this problem. Can someone pinpoint what I should look at? If you have umlauts in a name they turn out wrong in "customers" but everything is fine in "billers" or "invoices" etc. Example:
    Jürgen vs. Jürgen

    In the database everything looks OK. And I've compared the respective files in module "customers" and module "billers" but found no differences. I thought it was a minor charset issue. But as for the moment I'm lost.

  • modirmodir February 9

    Could the collation in the database be wrong?

  • ezbillingezbilling February 9

    No. Billers, customers etc. are all the same: utf8_unicode_ci. And as far as I understand collation only refers to the ordering - Quote MySQL: A collation is a set of rules for comparing characters in a character set.

    But if you say "wrong". Are you not having this issue (if you create a test customer via ALT-Keys since you won't have umlauts on your keyboard) ?

    Thanks for taking a shot.

  • modirmodir February 10

    I am from Switzerland and we have several customers and partners with umlauts too. But till now I never have experienced this problem. But it could be that we have the case that no customer has umlauts. I will test it once.

  • ezbillingezbilling February 10

    Well that would be nice. I already stated that "invoices" are OK. And that's the most important thing.

    Just to make it more clearly: Where umlauts turn out wrong is *solely* the customer screen (index.php?module=customers&view=manage). Therefore my first guess was the HTML charset-definition and consequently a template issue. But it says <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />Funny enough, even the detail view is OK
    (index.php?module=customers&view=details&id=8&action=edit). It's really just the customer overview. The necessary changes in the code must be minute. But where?

  • ezbillingezbilling February 10

    It's got to do with extension "default invoice" in case you're using it. In "xml.php" in folder "simpleinvoices/extensions/default_invoice/modules/customers" there are "utf_encodes" all over the place starting around line 110. Well, double-bagging doesn't help here ;-). Also, you'll probably want to touch "manage.js.php" in the same folder, because all translation options are out (compare with same file in folder "simpleinvoices/modules/customers").

  • modirmodir February 10

    Cool. Thank you. Can you open an issue here and attach the new files:
    http://code.google.com/p/simpleinvoices/issues/list

    I will then commit the code.

Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged