
Originally Posted by
chadderuski
Hi Nick,
Glad you got this working. Yes, those function calls are part of working with UTF-8 encoding for multi-byte (mb_) languages. Most english will encode in 1 byte, but some can take up to three if memory serves me correctly... Just be cautious with your string lengths as they may not get calculated correctly.
if that happens, and I'll use Manufacturer as the example, then you can end up with multiple truncated entries in the database:
So, Manufacturer's name exceeds database lenght:
"Hill Billy Manufacturing and Supplies Corp" is entered in your CSV file.
EP4 goes to add this to the database because it's new, but the string is truncated to the length in the database ( you'd see that in phpMyAdmin)
"Hill Billy Manufacturing and Supplies Corp" now becomes "Hill Billy Manufacturing an" in the database.
On the next line you have another item for this Manufacturer.... EP4 does a search on the manufacture's table and does not find a match, so it add that manufacturer AGAIN, and AGAIN it's truncated.... If you have 50 items with the same manufacturer, you end up with 50 entries in your manufacturer's table....
Not so damaging... BUT, this can also happen with Category Names! So please be careful to not exceed your database's field lengths.
Bookmarks