You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 troubleshooting → 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!
Sounds like you changed the users table to have a case sensitive collation.
Sounds like you changed the users table to have a case sensitive collation.
which means?
Run the following query
show table statusand paste the results
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
utf8_general_ci
ok but are there some way to change all the tables at the same time?
No, you have to run an alter table command for each one
Apologies. I completely misinterpreted that question. 
PunBB Forums → PunBB 1.2 troubleshooting → HELP! Something really strange with the sorting of userlist and search
Powered by PunBB, supported by Informer Technologies, Inc.