Re: switching from varchar to tinytext

2005-09-05 Thread Jason Pyeron
To test the char vs byte index I created a unique bcol(2), on a tiny text utf8 field. I then preceded to insert the numbers 00..99 in Chinese whose hex values are below. Since we are using utf8 vs ucs2 they are going to be 3 bytes per char, totaling 6 bytes per numbers. If the index is ind

Re: switching from varchar to tinytext

2005-09-04 Thread Jason Pyeron
On Sun, 4 Sep 2005, Alexey Polyakov wrote: Why do you choose to convert varchar to tinytext? Doesn't look like good idea to me. trailing spaces and mysql 4.x -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - -

Re: switching from varchar to tinytext

2005-09-04 Thread Alexey Polyakov
Bytes IIRC. Depending on actual content it can be 127-255 characters. Why do you choose to convert varchar to tinytext? Doesn't look like good idea to me. -- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E