"Rowland Carson" wrote: > It looks like a UTF-8 text file provides the correct answer when it's uploaded > to MySQL
You do not say which version of MySQL you are using, so there is no way to know what encoding options exist for you. They are different in later 4.x.x and 5.x versions of MySQL. "Beatrix Willius" wrote: > I would say that UTF16 is your best bet. Does mySQL expect the byte order mark > (BOM)? Does FMP write it? A good question but, again, you are not speaking about any specific version of MySQL, so your advice is not exactly useful in this form. "Beatrix Willius" wrote: > Another idea: UTF16 can be little or big endianness. 'endianness' is not a word (or computing term), of course. It is simply "little endian" and "bid endian". -- Gary
