Unicode characters in items, etc not working
Brought to you by:
jekkos,
pappastech
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
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.