#8 Unicode characters in items, etc not working

v1.0_(example)
open
1
2014-02-07
2013-04-17
Anonymous
No

Environment: Clean install, PHP 5.3.x, Apache server
Problem: Unicode characters (specifically Cyrillic but probably applies to all Unicode) are not allowed. Converted to ? characters.
Expected: Able to Enter, edit and search using Unicode characters.
Notes: I can manually edit the entry in PHPMyAdmin so it's not a limitation of the server environment but the code. If I edit the data in the database ospos spits out a db error:

Error Number: 1267

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

SELECT * FROM (ospos_items) WHERE item_number = 'лд'

Filename: /home/travis/public_html/pos/models/item.php

Line Number: 95

Discussion

  • objecttothis

    objecttothis - 2014-02-07
    • assigned_to: objecttothis
     
  • objecttothis

    objecttothis - 2014-02-07

    Is this still occuring in the latest version of OSPOS? A number of changes have been made that should fix the problem. Keep in mind that database updates need to be done when upgrading from older versions.