Jump to content


Photo

what is my MySQL DB's default CAHRACTER SET


  • Please log in to reply
No replies to this topic

#1 karthikeyan_coder

karthikeyan_coder
  • Members
  • PipPipPip
  • Advanced Member
  • 201 posts

Posted 15 April 2006 - 07:47 PM

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.



www.karthi.us




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users