Will column size change when trying to use single unicode character in place of multiple ASCII characters?

0 votes

1 answer

79 views

mysql database-design collation data-collection

                          I have a column in utf8_unicode_ci collation for text type in MySQL.

The content is in Unicode, I have used tags like {br}, {v}, {t}, {h} etc.., throught the database. I am now thinking of changing these to single characters from Unicode table like ⓑ, ⓥ, ⓣ, Ⓗ and so on  and so forth .

Will this have any effect on the size of the table? (Increase or decrease) Should I be worried about any other side effect? Will this have any effect if type of the column was varchar?

Asked by Jayarathina Madharasan (103 rep)

Jan 29, 2015, 01:48 PM
Last activity: Apr 30, 2015, 10:26 AM

Will column size change when trying to use single unicode character in place of multiple ASCII characters?

Related Questions