Hi, I recently upgraded to 2.3.0.
Everything went ok, and database was updated as well. However contact names in greek were not shown correctly.
They missed a portion of their name.
Some showed only the part before the first space and
some showed the part before the first space and last 1 or 2 letters from the part after the first space
This problem occured only in names in greek character encoding and not in others in latin characters
Fortunately I took a backup before the upgrade. I realized that field jos_nbill_contact.name was splitted in jos_nbill_contact.first_name and jos_nbill_contact.last_name.
Since I had I a similar issue in a project I work on, trying to split a full name into first and last name, I did a google search and found some suggestions. However they were not splitting very well for greek characters, in fact some showed similar results like the ones I experience in jos_nbill_contact table
So ended up using this code that works well for both latin and utf-8 greek characters
It sets last_name to the name portion before 1st space
and first_name the portion after 1st space
UPDATE jos_nbill_contact c SET
last_name =
(SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(c.name, ' ', 1), ' ', -1)),
first_name =
(SELECT LTRIM(SUBSTR(c.name,instr(c.name,' '))));
I thought I should share this info with you and help, in case it shows up to other users as well.
It might concern utf-8 encoding..
