UTF8 and the mysql table schema

Thank Prometheus.
I must be making mustakes with the MySQL syntax when I try to drop author as I just get errors all over the place in phpmyadmin. I think I need lessons! When you get some time could you put up a schema that I could try. Thanks very much.

I'm using MySQL - 4.1.19 and trying this query:

code>CREATE TABLE amazonitem(
ASIN varchar( 10 ) NOT NULL default '',
DetailPageURL text,
SmallImageURL varchar( 255 ) default '',
SmallImageHeight int( 10 ) unsigned default '0',
SmallImageWidth int( 10 ) unsigned default '0',
MediumImageURL varchar( 255 ) default '',
MediumImageHeight int( 10 ) unsigned default '0',
MediumImageWidth int( 10 ) unsigned default '0',
LargeImageURL varchar( 255 ) default '',
LargeImageHeight int( 10 ) unsigned default '0',
LargeImageWidth int( 10 ) unsigned default '0',
Binding varchar( 100 ) default '',
listAmount int( 10 ) unsigned default '0',
listCurrencyCode char( 3 ) default '',
listFormattedPrice varchar( 10 ) default '',
Title varchar( 100 ) NOT NULL default '',
Amount int( 10 ) unsigned default '0',
CurrencyCode char( 3 ) default '',
FormattedPrice varchar( 10 ) default '',
Availability varchar( 50 ) default '',
PriceDate datetime default '0000-00-00 00:00:00',
PRIMARY KEY ( ASIN ) ,
UNIQUE KEY ASIN( ASIN ) ,
) TYPE = MYISAM ;

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE = MYISAM' at line 25

Now I'm stumped. :-P

Hmm that looks like a semi-colon and was in the original. I've tried it without and still get an error. I've removed and jiggled commas and brackets but still get errors in the same area. I really can't get that to work. If anyone (including Prometheus! ;-)) can post a schema that doesn't include the author field and works I might be able to use the module! hehe Thanks very much. Meanwhile I'll jiggle the schema some more and try again.

I didn't identify what I did wrong pr5eviously but after you mentioned the author table wasn't used, rather than not create it I just shrunk it to 100 rather than 255 and that allowed the query through.

Cheers. :-)

Cheers for that! :-)