Problem with Batch Import
Posted by: Gianpiero Cicoira
Date: April 11, 2009 11:14AM

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


Options: ReplyQuote

Written By
Problem with Batch Import
April 11, 2009 11:14AM
April 29, 2009 05:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.