karthikeyan_coder Posted April 15, 2006 Share Posted April 15, 2006 hello,-- phpMyAdmin SQL Dump-- version 2.6.3-pl1-- Server version: 4.0.14-- PHP Version: 5.0.4while 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. Link to comment https://forums.phpfreaks.com/topic/7502-what-is-my-mysql-dbs-default-cahracter-set/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.