member list problem

[nikosb]

I have a promblem with member list
When you open http://url/forums/memberlist.php and choose one letter , it shows me only the names that the username beggins with "S" (CAPITAL)
and not the names withw ''small'' ''s''....

i Have vbseo and Does not work correctly with vbseo enable or disable.

Can you please tell me how to fix this promblem ?

Thank you for your time

[Zachery]

Does this only happen with S?

[nikosb]

it was an simple example

it happens with all letters

Thanks

[Zachery]

What is the character encoding for your database/tables/rows and have you ever changed or modified it? Also what is the connection encoding?

[nikosb]

1)conections encoding is utf-8
2)never change it
3) database table is utf8_bin

[Zachery]

In the AdminCP > Language & Settings > Edit Language what is the character encoding of the forum set to?

[nikosb]

UTF-8
charset=UTF-8

[Zachery]

utf8_bin: compare strings by the binary value of each character in the string

utf8_general_ci: compare strings using general language rules and using case-insensitive comparisons

utf8_general_cs: compare strings using general language rules and using case-sensitive comparisons

For example, the following will evaluate at true with either of the UTF8_general collations, but not with the utf8_bin collation:

Ä = A
Ö = O
Ü = U

With the utf8_general_ci collation, they would also return true even if not the same case.

I believe this should help explain things.

[nikosb]

thank you for the time
i got it
please tell me something else
is any way to return the utf8_bin to general_ci with one querie?

[Zachery]

I don't know of a single query, we think you should be able to change the encoding from bin to ci without much trouble but we would advise backing up first.

[nikosb]

Thanks Zachery
Fixed.