Hi!
Normally, people will choose lazy method, define default charset as
'utf8'. But based on the information of mysql, one might be able to define at
table level as 'utf-8' instead of whole database charset.
In normal case, only certain table or certain col might store
'utf-8' data. Hence I
Hello.
Is there something else I should be doing to create new users post
4.1?
Is this behavior something I should be worried about? (I am,
currently.)
Switch to the latest release (4.1.11). See also:
http://dev.mysql.com/doc/mysql/en/user-names.html
Adam Fields
I changed the default character set on a 4.1 server to utf8.
As expected, this caused the lengths of character fields to be
shortened, requiring alter table to be run on them to extend the
lengths.
But I didn't expect that this would also shorten the mysql system
tables (the mysql db), so that
Hello.
Is this a known issue?
It is interesting for me. According to the:
http://dev.mysql.com/doc/mysql/en/charset-metadata.html
MySQL stores usernames in utf8. Yes, you should convert your
tables to utf8, however, in my opinion, you don't have to do
this with 'mysql' database.
On Thu, May 12, 2005 at 10:08:33PM +0300, Gleb Paharenko wrote:
Hello.
Is this a known issue?
It is interesting for me. According to the:
http://dev.mysql.com/doc/mysql/en/charset-metadata.html
MySQL stores usernames in utf8. Yes, you should convert your
tables to utf8, however,