Re: unicode support for TEXT

[Jim Winstead]

There is no NTEXT type (yet, and I'm not aware of plans for one), but you can declare the character set of a TEXT type:

CREATE TABLE test ( data TEXT CHARACTER SET utf8 );

or just default all the columns to utf8:

CREATE TABLE test ( data TEXT ) DEFAULT CHARACTER SET utf8;

This requires MySQL 4.1 or later.

Jim Winstead
MySQL Inc.