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:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:5.0.77 OS:Microsoft Windows (2003)
Assigned to: CPU Architecture:Any
Tags: batch insert

[14 Apr 2009 20:26] Gianpiero Cicoira
Description:
Hello, 
I have a problem with a batch insert character set. 

If I try to import a large file, example single line: 

update immobili set descrizione='possibilità  di mutuo fino al 70 % palestra pluriuso' where id=1771870; 

with the command: 

mysql --user=root --password=password --database=db --default-character-set=latin1 -B -f -v <realestate.sql 

the result on db was: 

descrizione= possibilità di mutuo fino al 70 % palestra pluriuso 

with à instead à 

My db character set is latin1 mysql 5.0.77 

help

How to repeat:
update immobili set descrizione='possibilità  di mutuo fino al 70 % palestra pluriuso' where id=1771870; 

mysql --user=root --password=password --database=db --default-character-set=latin1 -B -f -v <realestate.sql
[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".