I found this from stack overflow
ALTER DATABASE ethioVision CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
but still cannot add file
Asked
Active
Viewed 171 times
0
Amila Senadheera
- 12,229
- 15
- 27
- 43
amanuel zerfu
- 33
- 1
- 7
-
What happens instead? What have you tried to resolve the problem? – Nico Haase Oct 19 '21 at 14:37
-
i restarted sql service after this but still the same, i was trying to import amharic(Ethiopian language) data. – amanuel zerfu Oct 19 '21 at 14:49
1 Answers
0
Changing the default character sets of a table or a schema does not change the data in the column itself, it only changes the default to apply the next time you add a table or add a column to a table.
To convert current data, alter one table at a time:
ALTER TABLE <name> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
Bill Karwin
- 538,548
- 86
- 673
- 828