I have two tables to wich php saves text data on user demand.
My design is as follows.
plan varchar(1000) - latin1_swedish_ci / this colum can recive foregn letters, but are saved coded in latin
fabric_canvas varchar(20 000) - latin1_swedish_ci / text from SVG file created by fabric.js
therapy varchar(500) - utf8_unicode_ci
material varchar(500) - utf8_unicode_ci
Will i suffer from performance drop if I set first table to utf8_unicode_ci, i have alredy set mysqli connection to utf8
Shuld i change only collum plan (first table) to utf8_unicode_ci and lessen the performance that way.
Or should i change bac everything to latin since it works fine sets all the letters fine
Is performance in this case negligible.