Hello Daniel On 2006-03-04 Daniel van Eeden wrote: > mysql> SELECT 'John Doe' as '__tañgè Ñãmé'; > +-------------------+ > | __tañgè Ñãmé | > +-------------------+ > | John Doe | > +-------------------+ > 1 row in set (0.00 sec) > > Why is the column with the unicode characters smaller than the other?
The problem will most likely be that the program counts the number of bytes that the column name takes to format it but unicode utf8 sometimes uses 2 bytes for 1 printed char so your terminal screws it up. Did you read all the chapters about setting the server charset in the docs? If you can confirm that mysql uses utf8 as internal charset too, then this is a bug. bye, -christian-