Jump to content

Archived

This topic is now archived and is closed to further replies.

karthikeyan_coder

what is my MySQL DB's default CAHRACTER SET

Recommended Posts

hello,
-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- Server version: 4.0.14
-- PHP Version: 5.0.4

while exporting my db i can get query like this...
CREATE DATABASE `dbname`;
USE dbname;

i just want to know what is my DB's default char set? coz now i want to insert my old db's backup sql file. it contains query like....

CREATE DATABASE `cpg` DEFAULT CHARACTER SET latin1 COLLATE atin1_swedish_ci;
USE cpg;

if i import that file in my db via phpmyadmin then i got error like...

syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35' at line.

i think this is happening cause of charset. coz that query was created by PLESK not by a human.

Please help me.


Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.