This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

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?
Reply
Thanks given by:


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: 2 Guest(s)