[BNM] Excel->CSV->Mysql (umlauts and stuff)

[Jason Bailey]

Hi
> Make sure that the encoding on your CSV is also set to UTF8. It might have
> ended up as 8859-1 (if memory serves). Nothing wrong with that, mind, but
> when importing anything it's best to have source and destination at the
> same encoding, and UTF8 is best for localisation imo. Most advanced text
> editors give you the option to save as a different encoding.


Thanks I think (I think fingers crossed) that it may be sorted. The default 
import set is UTF8 and so I tried a few others and cp1250 (windows central 
euro) seems to work. I can't see why UTF8 doesn't work unless there's a bug 
in phpmyadmin??

Oh! I see what you're saying now. on the file too!

cheers
Jason