Topic: HELP! Something really strange with the sorting of userlist and search

My userlist doesent work as it shuld.

Now its sorts the members like this:


a
b
c
.
.
.
z
A
B
C
..
Z



first the small and the the large

If I want the find the member John and search at a name for example:       john             , The search resault gets nothing..


I must search and log in with the exact right name to get it to work!

Re: HELP! Something really strange with the sorting of userlist and search

Sounds like you changed the users table to have a case sensitive collation.

Re: HELP! Something really strange with the sorting of userlist and search

Smartys wrote:

Sounds like you changed the users table to have a case sensitive collation.

which means?

Re: HELP! Something really strange with the sorting of userlist and search

Run the following query

show table status

and paste the results

5 (edited by staffanl 2007-12-14 06:51)

Re: HELP! Something really strange with the sorting of userlist and search

Oh I see the Collation is wrong!

How do I change all tables to the right one?




one more thing:  Im using utf8_bin now.

change to?

utf8_swedish_ci
ucs2_swedish_ci
swe7_bin
swe7_swedish_ci
latin1_swedish_ci

Re: HELP! Something really strange with the sorting of userlist and search

utf8_general_ci

Re: HELP! Something really strange with the sorting of userlist and search

ok but are there some way to change all the tables at the same time?

8

Re: HELP! Something really strange with the sorting of userlist and search

http://punbb.org/forums/viewtopic.php?id=17683

Re: HELP! Something really strange with the sorting of userlist and search

No, you have to run an alter table command for each one

10

Re: HELP! Something really strange with the sorting of userlist and search

Apologies. I completely misinterpreted that question. smile