PunBB Forums — HELP! Something really strange with the sorting of userlist and search

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

null@example.com (MattF) — Fri, 14 Dec 2007 23:47:29 +0000

Apologies. I completely misinterpreted that question.

null@example.com (Smartys) — Fri, 14 Dec 2007 22:07:45 +0000

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

null@example.com (MattF) — Fri, 14 Dec 2007 20:18:34 +0000

null@example.com (staffanl) — Fri, 14 Dec 2007 15:22:39 +0000

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

null@example.com (Smartys) — Fri, 14 Dec 2007 11:32:41 +0000

utf8_general_ci

null@example.com (staffanl) — Fri, 14 Dec 2007 06:44:20 +0000

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

null@example.com (Smartys) — Thu, 13 Dec 2007 20:19:28 +0000

Run the following query

show table status

and paste the results

null@example.com (staffanl) — Thu, 13 Dec 2007 20:08:02 +0000

Smartys wrote:

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

which means?

null@example.com (Smartys) — Thu, 13 Dec 2007 11:07:04 +0000

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

null@example.com (staffanl) — Thu, 13 Dec 2007 09:54:03 +0000

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!