localhost/phpmyadmin for conqueremu database

[Arcо]

Alright so I did some shiz in appserv.
Here's what I did.
I went to SQL and put this.

CREATE TABLE `cq_npc` (
  `id` int(4) unsigned zerofill NOT NULL default '0000',
  `ownerid` int(4) unsigned default '0',
  `playerid` int(4) unsigned default '0',
  `name` char(15) character set utf8 collate utf8_bin default '????¡§1??',
  `type` int(4) unsigned zerofill default '0000',
  `lookface` int(4) unsigned zerofill default '0000',
  `idxserver` int(4) default '-1',
  `mapid` int(4) unsigned zerofill default '0000',
  `cellx` int(4) unsigned zerofill default '0000',
  `celly` int(4) unsigned zerofill default '0000',
  `task0` int(4) unsigned zerofill default '0000',
  `task1` int(4) unsigned zerofill default '0000',
  `task2` int(4) unsigned zerofill default '0000',
  `task3` int(4) unsigned zerofill default '0000',
  `task4` int(4) unsigned zerofill default '0000',
  `task5` int(4) unsigned zerofill default '0000',
  `task6` int(4) unsigned zerofill default '0000',
  `task7` int(4) unsigned zerofill default '0000',
  `data0` int(4) NOT NULL default '0',
  `data1` int(4) NOT NULL default '0',
  `data2` int(4) NOT NULL default '0',
  `data3` int(4) NOT NULL default '0',
  `datastr` char(15) character set utf8 collate utf8_bin default '?T',
  `linkid` int(4) unsigned zerofill NOT NULL default '0000',
  `life` smallint(2) unsigned zerofill NOT NULL default '00',
  `maxlife` smallint(2) unsigned zerofill NOT NULL default '00',
  `base` int(4) unsigned zerofill NOT NULL default '0000',
  `sort` smallint(2) unsigned zerofill NOT NULL default '00',
  `itemid` int(4) unsigned zerofill default NULL,
  PRIMARY KEY  (`id`)
)

and I get the error

PHP Code:

#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 'collate utf8_bin default '????¡§1??',
  `type` int(4) unsigned 


Anybody know whats the deal?
I've reinstalled appserv many times and it does not help.

[Korvacs]

Which version of Sql is it? SQL Server 2005 doesnt support unsigned variables unless you write a custom server.

[Basser]

Ehm, try making the value 5 instead of 4, don't think that will work, but just try it.
At first I thought it was because an Int can't be unsigned, but that's not it, since MySQL does call UInts Usigned Ints.

[Korvacs]

Originally Posted by Smythe94

Ehm, try making the value 5 instead of 4, don't think that will work, but just try it.
At first I thought it was because an Int can't be unsigned, but that's not it, since MySQL does call UInts Usigned Ints.

Microsoft SQL Server doesnt support Unsigned ints of any kind, unless you write a custom server.