WebTechKitchen; Your Web Technology Kitchen, contact us to create, or maintain your websites and other digital properties.

ChatGPT

Submitted by barnettech on Wed, 06/14/2023 - 11:48

Embeddings versus Fine Tuning: https://youtu.be/_wtfszFzqt0
Forcing it to answer from the data given through embeddings, versus augmenting the sum of chatGPT data. From the spreadsheet example listing a bunch of animal names, which one is likely to speak English was asked, and it's forced to answer and choose from the list of animals, so it picked "Turtle" probably because of the Teenage Mutant Ninja turtles roflol!

Fix sql dump, Unknown collation: utf8mb4_0900_ai_ci

Submitted by barnettech on Fri, 01/13/2023 - 09:45
sed -i '' 's/utf8mb4_0900_ai_ci/utf8_general_ci/g' backup.sql  
sed -i '' 's/CHARSET=utf8mb4/CHARSET=utf8/g' backup.sql  

https://tecadmin.net/resolved-unknown-collation-utf8mb4_0900_ai_ci/

or this worked https://meetanshi.com/blog/error-1273-unknown-collation-utf8mb4-0900-ai…
just open the file and do %s/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g