MySQL Forums :: Character Sets, Collation, Unicode :: Problem with Batch Import


Advanced Search

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

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

Options: ReplyQuote


Subject Views Written By Posted
Problem with Batch Import 4056 Gianpiero Cicoira 04/11/2009 11:14AM
Re: Problem with Batch Import 2279 Devart Team 04/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.