devpro
devpro

Reputation: 16117

Is there any bad impact to using set name 'utf8' by default in selection?

Is there any bad impact to using set name 'utf8' by default in SQL select query?

Upvotes: 2

Views: 169

Answers (2)

Sahan De Silva
Sahan De Silva

Reputation: 471

The collation and the SET name may not have that vast impact on your project, but it doesn't mean that you shouldn't follow a standard collation method for the whole database. I prefer if you could go for a standard collation values, it would be less trouble for you.

Upvotes: 2

Zerium
Zerium

Reputation: 17333

I would say that there is no bad impact that I know of, but will be rather more tolerant with the input in terms of what is inputted, which might be a bad thing, but of what I know, it is a good thing.

Upvotes: 1

Related Questions