Menu

#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.

     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.