Dear all,
I am trying to import 250 accounts into the system.
Importing text like for example, Zürich is being importing as Zrüich.
I have changed the unicode while importing but brought nothing. then after the import I tried to rewrite the name. But it didn’t change in the database, and it does not come up whenever I search for it.
Any help is highly appreciated
I could save in the DB using the query SET NAMES ‘utf8’
But still unable to search…
Thank you
The only I can think may be the collation.
Execute the below in your Mysql. What are the values in the collation column?
SHOW TABLE STATUS FROM “”
And the below and write to us the results
SHOW VARIABLES LIKE ‘character_set%’;
SHOW VARIABLES LIKE ‘collation%’;
the collation is set to collutf8_general_ci
Thank you
SHOW VARIABLES LIKE ‘character_set%’;
character_set_client
utf8mb4
character_set_connection
utf8mb4
character_set_database
utf8
character_set_filesystem
binary
character_set_results
utf8mb4
character_set_server
latin1
character_set_system
utf8
character_sets_dir
C:\xampp\mysql\share\charsets\
SHOW VARIABLES LIKE ‘collation%’
collation_connection utf8mb4_german2_ci
collation_database utf8_general_ci
collation_server latin1_swedish_ci
Thank you!
Anyone has an idea?
I am able now to see the letters ü ä and ö but I am unable to search for them in the front end.
Thank you again