-- 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`;
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;
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.
what is my MySQL DB's default CAHRACTER SET
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users