Post reply

Reply to the message by Auge

Name:

E-mail: (optional, won't be displayed directly)

Leave this field empty:

Homepage: (optional)

Leave this field empty:

Location: (optional)

Remember me (cookie)

Category:

Subject:

Formatting help

skip to input

format text bold: [b]bold text[/b]
format text italic: [i]italic text[/i]
insert hyperlink: [link=http://example.com/]link text[/link] / [link]http://example.com/[/link]
set text color: [color=#rgb]colored text[/color]
font size: [size=small]small text[/size]; [size=large]large text[/size]
insert list: [list][*]list item[/list]
insert image: [img]http://example.com/image.jpg[/img]; left: [img=left]http://example.com/image.jpg[/img]; right: [img=right]http://example.com/image.jpg[/img]; thumbnail: [img=thumbnail]http://example.com/image.jpg[/img]; thumbnail left: [img=thumbnail-left]http://example.com/image.jpg[/img]; thumbnail right: [img=thumbnail-right]http://example.com/image.jpg[/img]
upload image: upload image ...
insert TeX code: [tex]TeX code[/tex]
insert code: [inlinecode]code[/inlinecode]; [code]code[/code]; [code=css]code[/code]; [code=html]code[/code]; [code=javascript]code[/code]; [code=perl]code[/code]; [code=php]code[/code]; [code=sql]code[/code]; [code=xml]code[/code]

:-)
;-)
:-P
:-D
:-|
:-(
:yes:
:no:
:ok:
:lol:
:lol2:
:lol3:
:cool:
:surprised:
:angry:
:crying:
:waving:
:confused:
:lookaround:
:clap:
:love:
:tick:

Message:

> Hello Milo
> 
> > > $update['errors'][] .= '<p>Please make the names unique and inform the users in question about the changes.</p>';
> > 
> > Hmm, I don't like this proposal. If once the user-name was valid, it should be valid all the time (like the Password: md5 --> sha1).
> 
> The problem with it is [i]the possibility[/i] of non-uniqueness of names. It came up, that the used collation [inlinecode]utf8_general_ci[/inlinecode] does not distinct between "a" and "ä" or "o" and "ø" and so on. So two different names could be realised as identically by the database. To change this I want to change the collation of only the column [inlinecode]mlf2_userdata.user_name[/inlinecode] to [inlinecode]utf8_bin[/inlinecode].
> 
> Because of the existing check for uniqueness of a user name during the registration it is very unlikely to duplicate a user name, but it is not impossible. It's possible, even it's very improbable, that the check failed. Thatswhy, [i]only for safety reasons[/i], I want to add the check in the update script. [b]I do not expect to find doublettes[/b] at all because (Daniels example) after the change of the collation the users "daniel" and "däniel" would never again found as identical and a second user with the name "daniel" or "däniel" would already now be rejected during the [inlinecode]<del>[/inlinecode]installation[inlinecode]</del><ins>[/inlinecode]registration[inlinecode]</ins>[/inlinecode] when other user(s) are registered under this/these name(s).
> 
> So this would be a safety net for the hypothetical case of a [i]bitwise[/i] non-unique user name. This case has to be prevented because the users with the questionable name have the real chance of not to be able to log in again.
> 
> Again, this is a very hypothetical case in my eyes.
> 
> Tschö, Auge

E-mail notification on reply of this posting