XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Usernames case sensitive
Register
1
knarf
Usernames case sensitive

  • 2006/2/27 21:53

  • knarf

  • Just popping in

  • Posts: 12

  • Since: 2005/3/2 1


Hi all,

Since my provider updated the MySQL database from version 3.23.58 to 5.0.18 the usernames are case sensitive. Does anyone has this problem to and is there a solution to solve this. It is quite irritating to use case-sensitive usernames i think,

Thanks,

Frank

PS. it looks like this problem:

https://xoops.org/modules/newbb/viewtopic.php?topic_id=44192&forum=3&post_id=193596#forumpost193596
2
knarf
Re: Usernames case sensitive

  • 2006/4/26 21:19

  • knarf

  • Just popping in

  • Posts: 12

  • Since: 2005/3/2 1


Hi All,

At last i found the solution (with the help of Jan of the Dutch support forums):

Change the characterset (collation) of the uname/loginname field of the users table to an case insensitive characterset. In my case i changed it to latin1_general_ci (ci stands for Case insensitive).

Greetings,
Frank

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

303 user(s) are online (247 user(s) are browsing Support Forums)

Members: 0

Guests: 303

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits