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
4089
April 11, 2009 11:14AM
2287
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.