Database collation
#1
Database collation
I never used Zpanel / Sentora for selling hosting to "customers" in way that i would let em use panel. Yes i do have few "clients" but i was/am only one ever accessing panel so i never came to filling account information stuff as i didin't need it etc.
Anyway, today i was testing Sentora and came to filling "account information" for myself. I realized that i can not fill my real name as some of "special" (central European) characters are rejected.
One quick look at database column collation and i can see that collation for "ud_fullname_vc" column is se to "latin1_swedish_ci".
After changing that to "utf8_general_ci" i can fill my name as i should.

I am wondering, is there a reason why it's "latin1_swedish_ci" and not "utf8_general_ci" or it's just a relic of the past that was never on the list for change?

Should i commit some changes to git related to this? Maybe not for all fields, but those that can safely be changed like ones in "x_profiles" tables?


Messages In This Thread
Database collation - by sosojni - 10-13-2014, 07:34 AM
RE: Database collation - by Me.B - 10-13-2014, 08:43 AM
RE: Database collation - by TGates - 10-13-2014, 09:20 AM
RE: Database collation - by sosojni - 10-13-2014, 09:57 AM
RE: Database collation - by sosojni - 10-13-2014, 09:59 AM
RE: Database collation - by TGates - 10-13-2014, 10:42 AM
RE: Database collation - by sosojni - 10-13-2014, 10:50 AM
RE: Database collation - by TGates - 10-13-2014, 12:21 PM
RE: Database collation - by Me.B - 10-16-2014, 06:03 AM
RE: Database collation - by kandrews - 10-16-2014, 06:09 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)