username, firstname and lastname need rules. about relate HOT 5 CLOSED

What's the issue with first/last? I don't see how either of those would cause an issue.

from relate.

Because I only see their name as "?" when they input with Chinese. Or let
me look into the issue later. Thanks.

2015-03-15 22:40 GMT+08:00 Andreas Klöckner [email protected]:

What's the issue with first/last? I don't see how either of those would
cause an issue.

—
Reply to this email directly or view it on GitHub
#6 (comment).

from relate.

I can't reproduce either issue you mention:

• I copy-paste some Chinese characters into first/last, and I wasn't able to find a place where they aren't shown correctly.
• I tried a user name with spaces in it, and I could sign in without a problem. I also couldn't find anything else that malfunctioned.

I'll close this for now. Feel free to reopen if you can provide a way to reproduce the issues you are seeing.

from relate.

What a shame of me, again! I should have google the issue before posting. The raised error is Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', and the solution was disccussed in: http://stackoverflow.com/questions/1008287/illegal-mix-of-collations-mysql-error

Thank you for your patience!

from relate.

No problem at all. Glad it got figured out.

from relate.