charset problem after moving db to local

Problems with the Windows version of XAMPP, questions, comments, and anything related.

charset problem after moving db to local

Postby zodehala » 06. January 2007 11:48

whenever i move to db from server to local and after restore it most of charcter is bad

ı must be ı
þ mus be Ş


i open db i have donloaded with MFC and like following

[quote]
-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- Üretim Zamanı: 24 Aralık 2006 saat 06:37:45
-- Sunucu sürümü: 4.1.21
-- PHP Sürümü: 4.4.2
--
-- Veritabanı: `forum_db`
--

-- --------------------------------------------------------

-- Tablo yapısı: `mos_categories`
--

CREATE TABLE `mos_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Tablo döküm verisi `mos_categories`
--

INSERT INTO `mos_categories` VALUES (1, 0, 'Haberler', 'Haberler', '4.gif', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 10, 0, 0, '');
INSERT INTO `mos_categories` VALUES (8, 0, 'Ankara Buluþmalarý', 'Ankara Buluþmalarý', '', 'com_events', 'left', 'Ankara Buluþmalarý', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 2, '');
INSERT INTO `mos_categories` VALUES (2, 0, 'Çarpýþma Testleri', 'Çarpýþma Testleri', 'crash.jpg', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 9, 0, 0, '');
INSERT INTO `mos_categories` VALUES (3, 0, 'Ayýn Otomobili', 'Ayýn Otomobili', '4.gif', '1', 'left', 'Agustos Ayýnýn Otomobili olarak bakýmýndan ve temizliginden dolayi Ã
zodehala
 
Posts: 22
Joined: 08. August 2006 12:39

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 131 guests