« Project home page
my little forum
Log in
Register
Search:
Back to the entry by danielb987
Post reply
Reply to the message by
danielb987
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:
General
Project organisation
Technics
Design/Themes
Features
Development
Todo
Bugs
German / Deutsch
Spanish / Español
French / Français
Accessibility/UX
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 > > > > > I have a Swedish forum there some of the users have Swedish characters in their user names. I have now noticed that if two users have user names that looks alike but are different, they will not be able to login. > > > > > > Example: > > > One user has the user name "daniel" and the other user has the user name "däniel". > > > > I can confirm this misbehaviour in one of [inlinecode]<del>[/inlinecode]my accessible[inlinecode]</del>[/inlinecode] servers [inlinecode]<ins>[/inlinecode]I have access to[inlinecode]</ins>[/inlinecode]. The reason is the use of the collation [inlinecode]utf8_general*[/inlinecode]. A [link=http://50226.de/mysql-umlaute-und-utf-8.html]blog entry (in german language)[/link] offers a solution, the use of the collation [inlinecode]utf8_bin[/inlinecode]. But this has the same issues like your unique index and has to be implemented equally careful. > > > > Tschö, Auge > > In the case with the user name, it is a problem. But in general I think this is a very useful feature. For example, a danish user may search for a word with the letter Ø then the word contains the Swedish letter Ö. > > Best regards > Daniel
E-mail notification on reply of this posting
OK - Submit
Preview