Forums

whenever i try to add new row in my table using rest api i get this error(mysql.connector.errors.DatabaseError) 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci'

i'm not storing any emoji in database but only string and integer but still getting the above error I've alter the table and and database charset and collation using the command-

 ALTER DATABASE teamip$Investments CHARACTER SET utf8 COLLATE utf8_general_ci;

and

ALTER TABLE InvestmentLedger CHARACTER SET utf8mb4 COLLATE utf8_general_ci;

but nothing happens

i am working on this error since last night and tried everything to resiolve this , please help me..

Have a look on a reply in this thread.