Re: import utf8 to latin
Posted by: Olivier Goossens Bara
Date: May 18, 2009 01:27AM

Hello

I also try the operation below without success

truncate table nam;
set names utf8;
LOAD DATA INFILE 'c:\\tmp\\nam.csv'
INTO TABLE nam
FIELDS ENCLOSED BY "" TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'

Source is like this

5477 1 1 Antuérpia
5478 1 1 Anvers
6305 1 1 Vlaams Gewest
6306 1 1 Flemish Region
6307 1 1 Flämisch Region
6308 1 1 Région Flamande
6309 1 1 Regione Fiamminga
6310 1 1 Región Flamenca
6311 1 1 Flamsk Region
6312 1 1 Flamlänskt region
6313 1 1 Flamsk Region
6334 1 1 België
6335 1 1 Belgium
6336 1 1 Belgien
6337 1 1 Belgique
6338 1 1 Belgio
6339 1 1 Bélgica
6340 1 1 Bélgica

Options: ReplyQuote


Subject
Views
Written By
Posted
7837
May 14, 2009 09:33AM
6819
May 14, 2009 03:08PM
Re: import utf8 to latin
2960
May 18, 2009 01:27AM


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.