Bug #44274 | Invalid character set with à instead à | ||
---|---|---|---|
Submitted: | 14 Apr 2009 20:26 | Modified: | 16 May 2009 6:57 |
Reporter: | Gianpiero Cicoira | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
Version: | 5.0.77 | OS: | Windows (2003) |
Assigned to: | CPU Architecture: | Any | |
Tags: | batch insert |
[14 Apr 2009 20:26]
Gianpiero Cicoira
[15 Apr 2009 6:36]
Sveta Smirnova
Thank you for the report. Please provide output of SHOW CREATE TABLE immobili
[15 Apr 2009 19:14]
Gianpiero Cicoira
Thanks, this is the Script CREATE TABLE `cercasicasa`.`immobili` ( `id` bigint(20) unsigned NOT NULL auto_increment, `scopo` varchar(20) default NULL, `contratto` varchar(40) default NULL, `condizioni` varchar(40) default NULL, `lire` decimal(10,0) default NULL, `euro` decimal(10,0) default '0', `nazione` varchar(40) default NULL, `regione` varchar(30) default NULL, `citta` varchar(70) default NULL, `provincia` varchar(40) default NULL, `indirizzo` varchar(255) default NULL, `cap` varchar(6) default NULL, `quartiere` varchar(255) default NULL, `zonax` varchar(10) default NULL, `tipologia` varchar(50) default NULL, `vani` varchar(15) default NULL, `superficie` varchar(15) default NULL, `piano` varchar(15) default NULL, `descrizione` text, `username` varchar(10) default NULL, `id_utente` int(11) default NULL, `file1` varchar(250) default NULL, `file2` varchar(250) default NULL, `file3` varchar(250) default NULL, `file4` varchar(250) default NULL, `stato` varchar(50) default NULL, `data` datetime default NULL, `posti_letto` int(11) default NULL, `dispda` datetime default NULL, `dispal` datetime default NULL, `Inquilini` int(11) default NULL, `sesso` varchar(5) default NULL, `ID_immobile_PI` int(10) default NULL, `ID_agenzia_PI` int(10) default NULL, `rifagenzia` varchar(100) default NULL, `nemail` int(10) default '0', `nvisite` int(10) default '0', `scadenza` int(10) default '0', `noteprezzo` varchar(50) default NULL, `longitudine` varchar(20) default NULL, `latitudine` varchar(20) default NULL, `id_fonte` int(11) default NULL, `data_scadenza` datetime default NULL, `link_immobile` varchar(255) default NULL, `tags` varchar(500) default NULL, `ip` varchar(15) default NULL, `u` tinyint(1) default '1', PRIMARY KEY (`id`), KEY `IdFonte` (`id_utente`,`id_fonte`), KEY `locimmobili` (`nazione`,`regione`,`provincia`,`citta`,`stato`,`file1`,`scopo`), KEY `ImmobiliScStF1` (`scopo`,`file1`,`stato`), KEY `ImmobiliCittaStato` (`citta`,`stato`), KEY `ImmobiliRegStaF1` (`regione`,`stato`,`file1`), KEY `ImmobiliNazStaF1` (`nazione`,`stato`,`file1`), KEY `Index_Foto` (`file1`,`file2`,`file3`,`file4`), KEY `Index_Delete` (`id_fonte`,`data_scadenza`,`stato`,`scadenza`,`data`), KEY `IndexImmobili` (`id_utente`,`stato`,`contratto`,`tipologia`,`citta`,`scopo`), KEY `ImmobiliProStaF1` USING BTREE (`provincia`,`stato`,`file1`), KEY `Index_PortaliImmobiliari` USING BTREE (`ID_immobile_PI`), FULLTEXT KEY `Index_FullText` (`nazione`,`regione`,`provincia`,`citta`,`scopo`,`condizioni`,`contratto`,`indirizzo`,`tipologia`,`quartiere`,`descrizione`) ) ENGINE=MyISAM AUTO_INCREMENT=2790677 DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1;
[16 Apr 2009 6:57]
Sveta Smirnova
Thank you for the feedback. I can not repeat described behavior. Please also provide output of SHOW VARIABLES LIKE '%char%' and SHOW VARIABLES LIKE '%coll%'
[16 May 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".