padėkit dėl .sql

[TycKa]

Štai .sql failas

http://pastebin.com/MPQn4PRK

O kai ant localhost meginu importinti i duomenu baze gaunu tokia klaidą:

http://pastebin.com/BarRKyNU

[bebras]

Senajį "CREATE TABLE IF NOT EXISTS `namai` pakeisk į šitą:

CREATE TABLE IF NOT EXISTS `namai` (
 `NamasID` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Savininkas` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
 `Namas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `POS_X` FLOAT NOT NULL,
 `POS_Y` FLOAT NOT NULL,
 `POS_Z` FLOAT NOT NULL,
 `CAMPOS_X` FLOAT NOT NULL,
 `CAMPOS_Y` FLOAT NOT NULL,
 `CAMPOS_Z` FLOAT NOT NULL,
 `Nuomininkas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `NuomosKaina` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `KainaLT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `KainaCT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `VidausID` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Nesumoketa` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `PadetaPinigu` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Susimoketa` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Raktas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Nuoma` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;

[TycKa]

Senajį "CREATE TABLE IF NOT EXISTS `namai` pakeisk į šitą:

CREATE TABLE IF NOT EXISTS `namai` (
`NamasID` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`Savininkas` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
`Namas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`POS_X` FLOAT NOT NULL,
`POS_Y` FLOAT NOT NULL,
`POS_Z` FLOAT NOT NULL,
`CAMPOS_X` FLOAT NOT NULL,
`CAMPOS_Y` FLOAT NOT NULL,
`CAMPOS_Z` FLOAT NOT NULL,
`Nuomininkas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`NuomosKaina` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`KainaLT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`KainaCT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`VidausID` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`Nesumoketa` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`PadetaPinigu` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`Susimoketa` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`Raktas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
`Nuoma` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;

Dabr dėl nariai kažkas negerai:

Klaida
SQL užklausa:
-- -------------------------------------------------------- -- -- Sukurta duomenų struktūra lentelei `nariai` -- CREATE TABLE IF NOT EXISTS `nariai` ( `Vardas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Health` FLOAT NOT NULL, `Slaptazodis` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `balsas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Xp` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Admin` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Vip` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Interjeras` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Skin` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Alga` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `AlgaCT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Naujokas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Kreditai` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `PinigaiR` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL, `Pini[...]
MySQL atsakymas: ?
#1115 - Unknown character set: 'utf8mb4'

[bebras]

CREATE TABLE IF NOT EXISTS `nariai` (
 `Vardas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Health` FLOAT NOT NULL,
 `Slaptazodis` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `balsas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Xp` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Admin` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Vip` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Interjeras` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Skin` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Alga` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `AlgaCT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Naujokas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Kreditai` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `PinigaiR` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `PinigaiB` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `PinigaiL` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `PinigaiRCT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `PinigaiBCT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `PinigaiLCT` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `bankokortele` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
 `POS_X` DOUBLE NOT NULL,
 `POS_Y` DOUBLE NOT NULL,
 `POS_Z` DOUBLE NOT NULL,
 `Angle` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `World` VARCHAR(20) COLLATE utf8_lithuanian_ci NOT NULL,
 `TelNr` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `saskaita` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Telefonas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `telon` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Tinklas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Perziurejo` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `lytis` VARCHAR(20) COLLATE utf8_lithuanian_ci NOT NULL,
 `darbasrangas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `darbas` VARCHAR(20) COLLATE utf8_lithuanian_ci NOT NULL,
 `darbasu` VARCHAR(20) COLLATE utf8_lithuanian_ci NOT NULL,
 `darbasua` VARCHAR(20) COLLATE utf8_lithuanian_ci NOT NULL,
 `direktorius` VARCHAR(20) COLLATE utf8_lithuanian_ci NOT NULL,
 `direktoriusrangas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `carteises` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `mototeises` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `lektuvteises` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `sunkvezteises` VARCHAR(50) CHARACTER SET ucs2 COLLATE ucs2_lithuanian_ci NOT NULL,
 `vmpakviestas` VARCHAR(20) COLLATE utf8_lithuanian_ci NOT NULL,
 `vmcekisa` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `vmcekisb` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `vmcekisdc` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `vmcekisl` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `sumokejovmt` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `teorija` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Masina` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Masinaid` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Prisijunges` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `sumokejovm` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
 `vmtestas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Banned` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Jail` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ieskomumas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `pakviete` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `medsp` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `ispejimai` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `buvocar` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `biznis` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `biznisid` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `namas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `namasid` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `nuoma` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `nuomaid` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `nuomaraktas` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon0` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo0` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon1` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo1` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon2` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo2` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon3` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo3` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon4` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo4` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon5` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo5` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon6` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo6` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon7` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo7` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon8` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo8` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon9` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo9` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon10` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo10` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Weapon11` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Ammo11` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `degtukai` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `ziebtuvelis` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `cigaretes` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `gauja` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL,
 `Speedometras` VARCHAR(50) COLLATE utf8_lithuanian_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;

Ir išvis, aš tik pakeičiu juos į "utf8", jei bus dar tokį error, padaryk tapatį.