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
