Hi,

Is there 'NVARCHAR' datatype available in mysql. If so, how to use the same in create table statements. I tried the following :

create table test(sno nvarchar(70))

I got the following error :

Check the manual that corresponds to your MySQL server version for the right syntax to use near NVARCHAR (70).

Please advice.

Thanks,
Sam

If you are running MySQL 4.1.1 or later, use UNICODE where MS-SQL would use NVARCHAR.

-PatP