Jump to content


Photo

Character Sets


  • Please log in to reply
1 reply to this topic

#1 simardbrad

simardbrad

    Junior Member

  • Member
  • Pip
  • 33 posts

Posted 11 October 2005 - 05:55 PM

Hey, the phpmyadmin that comes with 3.2a has

character set: ISO 8859-1 West European (latin1)
collation: latin1_swedish_ci

but I want to export my sql and put it on a server that I don't know what it has, but when I try to import the sql file onto the other server, it gives me this error:

Error 
SQL query: 

-- phpMyAdmin SQL Dump
-- version 2.6.3-rc1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 11, 2005 at 06:52 PM
-- Server version: 4.1.12
-- PHP Version: 5.0.4
-- 
-- Database: `site`
-- 
-- --------------------------------------------------------
-- 
-- Table structure for table `admin`
-- 
CREATE TABLE `admin` (

`username` varchar( 255 ) default NULL ,
`email` varchar( 255 ) default NULL ,
`password` varchar( 255 ) default NULL ,
`vcode` varchar( 255 ) default NULL 
) ENGINE = MYISAM DEFAULT CHARSET = latin1 
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 'DEFAULT CHARSET=latin1' at line 24  


#2 olajideolaolorun

olajideolaolorun

    Project Manager

  • Admin
  • PipPipPipPipPip
  • 2,347 posts
  • Gender:Male
  • Location:Atlanta, GA
  • SourceForge IDempirex
  • Wiki ID: olajideolaolorun
  • IRC Nickname: Olajide
  • Main OS: Windows 10

Posted 11 October 2005 - 09:47 PM

Just remove this: ENGINE = MYISAM DEFAULT CHARSET = latin1

Might not be of use on your server's version :)




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users