Mike Aubury schrieb: > Excellent - this seems to be the issue - the show create table shows : > > mysql> show create table a\g > +-------+----------------------------------------------------------------------------------------+ > | Table | Create > Table > | > +-------+----------------------------------------------------------------------------------------+ > | a | CREATE TABLE `a` ( > `blah` char(20) default NULL > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | > +-------+----------- > > > So - its utf8 (which I understand enough about to understand why its doing > what its doing!) > > So - the next question is... > Is there anyway in code I can find the 'fiddle' factor (1,3,or now possibly > 4) > that I need to use to divide by to get back to the character width specified > in the CREATE TABLE ? > >
why do you want to do that ? i would expect that mysql uses wchar_t for char() if utf8 is selected. re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]