[Err] 1300 - Invalid utf8 character string: 'Pr\xE4sidentverdienst'
[Err] /*
Navicat MySQL Data Transfer
Source Server : Localhost
Source Server Version : 50527
Source Host : localhost:3306
Source Database : samp
Target Server Type : MYSQL
Target Server Version : 50527
File Encoding : 65001
Date: 2012-12-20 20:51:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `autos`
-- ----------------------------
DROP TABLE IF EXISTS `autos`;
CREATE TABLE `autos` (
`AutoID` int(11) NOT NULL AUTO_INCREMENT,
`CarID` int(11) NOT NULL,
`Typ` int(11) NOT NULL,
`BesitzerID` int(11) NOT NULL,
`BesitzerName` varchar(255) NOT NULL,
`Farbe1` int(11) NOT NULL,
`Farbe2` int(11) NOT NULL,
`Tank` int(11) NOT NULL,
`MaxTank` int(11) NOT NULL,
`Verbrauch` int(11) NOT NULL,
`Damaged` int(11) NOT NULL,
`Kilometerstand` int(11) NOT NULL,
`Nummernschild` varchar(255) NOT NULL,
`PositionX` varchar(255) NOT NULL,
`PositionY` varchar(255) NOT NULL,
`PositionZ` varchar(255) NOT NULL,
`Angle` varchar(255) NOT NULL,
PRIMARY KEY (`AutoID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of autos
-- ----------------------------
-- ----------------------------
-- Table structure for `extras`
-- ----------------------------
DROP TABLE IF EXISTS `extras`;
CREATE TABLE `extras` (
`TaxiPreis` int(11) NOT NULL,
`Steuern` int(11) NOT NULL,
`V_Steuern` int(11) NOT NULL,
`Staatsgeld` int(11) NOT NULL,
`Lottogewinn` int(11) NOT NULL,
`Lottolospreis` int(11) NOT NULL,
`ArrestBelohnung` int(11) NOT NULL,
`Polizeiverdienst` int(11) NOT NULL,
`FBIverdienst` int(11) NOT NULL,
`Armyverdienst` int(11) NOT NULL,
`Feuerwehrverdienst` int(11) NOT NULL,
`Pr�sidentverdienst` int(11) NOT NULL,
`Newsverdienst` int(11) NOT NULL,
`Taxiverdienst` int(11) NOT NULL,
`Fahrschulverdienst` int(11) NOT NULL,
`Adacverdienst` int(11) NOT NULL,
`Lufthansaverdienst` int(11) NOT NULL,
`Meteorologenverdienst` int(11) NOT NULL,
`Krankenhausverdienst` int(11) NOT NULL,
`Flugverbot` int(11) NOT NULL,
`Wetterwarnung` varchar(128) NOT NULL,
`Wetter` int(11) NOT NULL,
`Stromkosten` int(11) NOT NULL,
`Heizkosten` int(11) NOT NULL,
`LetzteIP` varchar(64) NOT NULL DEFAULT '127.0.0.1',
`Klicks` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of extras
-- ----------------------------
INSERT INTO `extras` VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Sonne in San Andreas', '1', '0', '0', '127.0.0.1', '0');
-- ----------------------------
-- Table structure for `homes`
-- ----------------------------
DROP TABLE IF EXISTS `homes`;
CREATE TABLE `homes` (
`HausID` int(11) NOT NULL AUTO_INCREMENT,
`Hausname` varchar(255) NOT NULL,
`Gekauft` int(11) NOT NULL,
`Maklerkauf` int(11) NOT NULL,
`Maklerverkauf` int(11) NOT NULL,
`Verkaufpreis` int(11) NOT NULL,
`Maklerverkaufspreis` int(11) NOT NULL,
`Vermietet` int(11) NOT NULL,
`MietenErlauben` int(11) NOT NULL,
`Hausbesitzer` varchar(255) NOT NULL,
`Mieter` varchar(255) NOT NULL,
`Preis` int(11) NOT NULL,
`Mietpreis` int(11) NOT NULL,
`Ort` int(11) NOT NULL,
`Ortname` varchar(255) NOT NULL,
`Postleitzahl` int(11) NOT NULL,
`Hausnummer` int(11) NOT NULL,
`Abgeschlossen` int(11) NOT NULL,
`EingangX` varchar(255) NOT NULL,
`EingangY` varchar(255) NOT NULL,
`EingangZ` varchar(255) NOT NULL,
`EingangAngle` varchar(255) NOT NULL,
`Interior` int(11) NOT NULL,
`AusgangX` varchar(255) NOT NULL,
`AusgangY` varchar(255) NOT NULL,
`AusgangZ` varchar(255) NOT NULL,
`AusgangAngle` varchar(255) NOT NULL,
PRIMARY KEY (`HausID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of homes
-- ----------------------------
-- ----------------------------
-- Table structure for `jobkassen`
-- ------------
[Msg] Finished - Unsuccessfully
--------------------------------------------------
bei navicat kommt das o,o bitte help danke
