Hi all
I'm using mySQL/PHP on a macOSX machine and found myslf in trouble while trying to
import data from our filemaker pro database.
I export from filepaker as comma delimited and then import using the LOAD DATA INFILE.
This works like a charm, but all the accents get imported incorrectly. For instance,
the work 'Köln' (the second character here should be an o with an umlaut on it) goes
all wrong. I do know that the export runs fine, since after opening the
comma-delimited file with a text-editor such as BBEdit (a macOSX thingie) the
characters show up correctly.
When importing though, things are bad, since a simple SQL statement will show weird
characters instead of the ö.
It took me a looooooooong time, but finnaly i found out that, when I view the file
with vi, "Köln" is shown as "K\x9aln". This is wrong, since a copy-paste shows me that
it should be "K\xf6ln" !
what am I doing wrong ??????????? Viewing the file with BBedit or any other texteditor
seems to show it correctly....
is there anyone wityh similar experience ??????
[EMAIL PROTECTED]
