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

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

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,

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. C