Encoding-problemer

Hvis det er en "fremmed" PHP applikation du har installeret, er det umiddelbart svært at gisne om, hvor fejlen ligger.

Kan du lave et dump af en tabel med  ? i ????
Så kan jeg lige kigge på det!

//sostack

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Vært: localhost
-- Genereringstid: 14/04 2005 kl. 15:00:07
-- Serverversion: 4.1.11
-- PHP version: 5.0.4
--
-- Database: `dotproject`
--

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

--
-- Struktur-dump for tabellen `tasks`
--

CREATE TABLE `tasks` (
  `task_id` int(11) NOT NULL auto_increment,
  `task_name` varchar(255) collate latin1_general_ci default NULL,
  `task_parent` int(11) default '0',
  `task_milestone` tinyint(1) default '0',
  `task_project` int(11) NOT NULL default '0',
  `task_owner` int(11) NOT NULL default '0',
  `task_start_date` datetime default NULL,
  `task_duration` float unsigned default '0',
  `task_duration_type` int(11) NOT NULL default '1',
  `task_hours_worked` float unsigned default '0',
  `task_end_date` datetime default NULL,
  `task_status` int(11) default '0',
  `task_priority` tinyint(4) default '0',
  `task_percent_complete` tinyint(4) default '0',
  `task_description` text collate latin1_general_ci,
  `task_target_budget` decimal(10,2) default '0.00',
  `task_related_url` varchar(255) collate latin1_general_ci default NULL,
  `task_creator` int(11) NOT NULL default '0',
  `task_order` int(11) NOT NULL default '0',
  `task_client_publish` tinyint(1) NOT NULL default '0',
  `task_dynamic` tinyint(1) NOT NULL default '0',
  `task_access` int(11) NOT NULL default '0',
  `task_notify` int(11) NOT NULL default '0',
  `task_departments` varchar(100) collate latin1_general_ci default NULL,
  `task_contacts` varchar(100) collate latin1_general_ci default NULL,
  `task_custom` longtext collate latin1_general_ci,
  `task_type` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`task_id`),
  KEY `idx_task_parent` (`task_parent`),
  KEY `idx_task_project` (`task_project`),
  KEY `idx_task_owner` (`task_owner`),
  KEY `idx_task_order` (`task_order`),
  KEY `task_start_date` (`task_start_date`),
  KEY `task_end_date` (`task_end_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=734 ;

--
-- Data dump for tabellen `tasks`
--

INSERT INTO `tasks` VALUES (2, 'Installation af Unix', 2, 1, 2, 4, '2003-08-01 00:00:00', 0, 1, 0, '2003-08-04 00:00:00', 0, 0, 15, '', 0.00, '', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0);
INSERT INTO `tasks` VALUES (353, 'Filen projects.MYI er ?delagt', 353, 0, 27, 2, '2004-01-09 08:00:00', 1, 1, 0, '2004-01-09 08:00:00', 0, 0, 100, 'Da jeg oprettede et projekt i dotproject blev filen projects.MYI ?delagt', 0.00, '', 0, 0, 0, 0, 0, 1, '', '', NULL, 0);
INSERT INTO `tasks` VALUES (259, 'Sorteringsanl?g mangler svar', 259, 0, 28, 4, '2003-10-28 00:00:00', 1, 1, 0, '2003-10-29 00:00:00', 0, 0, 10, 'N?r et bestemt materiale bliver afleveret, f?r sorteringsanl?get ikke noget svar', 0.00, '', 0, 0, 0, 0, 0, 1, NULL, NULL, NULL, 0);
INSERT INTO `tasks` VALUES (12, 'Regul?re udtryk', 12, 0, 6, 2, '2003-03-05 00:00:00', 1, 24, 0, '2003-03-06 00:00:00', 0, 0, 100, NULL, 0.00, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0);
INSERT INTO `tasks` VALUES (14, 'Inds?t del-strenge i felter', 14, 0, 6, 2, '2003-03-10 00:00:00', 1, 24, 0, '2003-03-11 00:00:00', 0, 0, 100, NULL, 0.00, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0);

Prøv med:
DROP TABLE `tasks`;

CREATE TABLE `tasks` (
  `task_id` int(11) NOT NULL auto_increment,
  `task_name` varchar(255) default NULL,
  `task_parent` int(11) default '0',
  `task_milestone` tinyint(1) default '0',
  `task_project` int(11) NOT NULL default '0',
  `task_owner` int(11) NOT NULL default '0',
  `task_start_date` datetime default NULL,
  `task_duration` float unsigned default '0',
  `task_duration_type` int(11) NOT NULL default '1',
  `task_hours_worked` float unsigned default '0',
  `task_end_date` datetime default NULL,
  `task_status` int(11) default '0',
  `task_priority` tinyint(4) default '0',
  `task_percent_complete` tinyint(4) default '0',
  `task_description` text,
  `task_target_budget` decimal(10,2) default '0.00',
  `task_related_url` varchar(255)  default NULL,
  `task_creator` int(11) NOT NULL default '0',
  `task_order` int(11) NOT NULL default '0',
  `task_client_publish` tinyint(1) NOT NULL default '0',
  `task_dynamic` tinyint(1) NOT NULL default '0',
  `task_access` int(11) NOT NULL default '0',
  `task_notify` int(11) NOT NULL default '0',
  `task_departments` varchar(100)  default NULL,
  `task_contacts` varchar(100)  default NULL,
  `task_custom` longtext ,
  `task_type` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`task_id`),
  KEY `idx_task_parent` (`task_parent`),
  KEY `idx_task_project` (`task_project`),
  KEY `idx_task_owner` (`task_owner`),
  KEY `idx_task_order` (`task_order`),
  KEY `task_start_date` (`task_start_date`),
  KEY `task_end_date` (`task_end_date`)
) TYPE=MyISAM;


INSERT INTO `tasks` VALUES (2, 'Installation af Unix', 2, 1, 2, 4, '2003-08-01 00:00:00', 0, 1, 0, '2003-08-04 00:00:00', 0, 0, 15, '', 0.00, '', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0);
INSERT INTO `tasks` VALUES (353, 'Filen projects.MYI er ødelagt', 353, 0, 27, 2, '2004-01-09 08:00:00', 1, 1, 0, '2004-01-09 08:00:00', 0, 0, 100, 'Da jeg oprettede et projekt i dotproject blev filen projects.MYI ødelagt', 0.00, '', 0, 0, 0, 0, 0, 1, '', '', NULL, 0);
INSERT INTO `tasks` VALUES (259, 'Sorteringsanlæg mangler svar', 259, 0, 28, 4, '2003-10-28 00:00:00', 1, 1, 0, '2003-10-29 00:00:00', 0, 0, 10, 'Når et bestemt materiale bliver afleveret, får sorteringsanlæget ikke noget svar', 0.00, '', 0, 0, 0, 0, 0, 1, NULL, NULL, NULL, 0);
INSERT INTO `tasks` VALUES (12, 'Regulære udtryk', 12, 0, 6, 2, '2003-03-05 00:00:00', 1, 24, 0, '2003-03-06 00:00:00', 0, 0, 100, NULL, 0.00, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0);
INSERT INTO `tasks` VALUES (14, 'Indsæt del-strenge i felter', 14, 0, 6, 2, '2003-03-10 00:00:00', 1, 24, 0, '2003-03-11 00:00:00', 0, 0, 100, NULL, 0.00, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0);


//sostack

Du ledte mig på rette spor sostack. Problemet er opstået ved at jeg eksporterede til en fil og indlæste denne fil via phpMyAdmin. Filens encoding var åbentbart forkert.
Jeg har nu genskabt hele databasen ved at submitte sql-koden direkte istedet for en fil - og det hjalp.

Læg et svar, så får du pointene.

Oki, glad for at kunne hjælpe!

//sostack

Værs'go! :o)

Jeg kan ikke se at den har registreret min Accept. Kan man ikke se det?

Det var bedre.