Bug Missed collation for some fields in DB

[DimitryMarvel]

Table "xf_dbtech_shop_currency"
Field "description"

Collation utf8mb4_general_ci missed.


In Forum charset is ok, but in DB this field is not readable.


Same problem for table "xf_dbtech_credits_currency.description".
I would check others fields too, maybe there is more with this problem.

 

[Fillip H.]

This is not a missing collation. BLOB fields cannot have a collation, because they are binary storage. What you are seeing is your MySQL query UI's ASCII representation of binary data.

This is not a bug.

 

[DimitryMarvel]

Ok.
And why this field has type "BLOB" and not "VARCHAR" or "MEDIUMTEXT"?

 

[Fillip H.]

Because blob is the new standard in XF.

 

[DimitryMarvel]

Standard for what? For example, xf_style.description, xf_post.message isn't blob.

 

[Fillip H.]

I don't understand why this is so important to you. In either case, I've explained why the blob fields do not have any character set and why this is not a bug, so I'll go ahead and close this.