Re: utf8, 4.1, and character length truncation in mysql system tables

2005-05-15 Thread Pengz9
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

Re: utf8, 4.1, and character length truncation in mysql system tables

2005-05-13 Thread Gleb Paharenko
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

utf8, 4.1, and character length truncation in mysql system tables

2005-05-12 Thread 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

Re: utf8, 4.1, and character length truncation in mysql system tables

2005-05-12 Thread Gleb Paharenko
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.

Re: utf8, 4.1, and character length truncation in mysql system tables

2005-05-12 Thread Adam Fields
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,