You can use FMP 8.5.
Re: my post on the Blueworld FMPro list:
_____________________
Hi Rowland,
FMP Developer 7 and 8 Advanced can export as UTF 16 (as well as
Windows [ANSI], ASCII [DOS], Macintosh, and Japanese [Shift-JIS]).
If Tab- or comma-delimited text is chosen, FMP 8.5 Advanced can
export as UTF 8 and UTF 16, as well as the afore-mentioned character
sets, and Simplified Chinese (GB) and Traditional Chinese (Big-5).
(However, if other export options are chosen in 8.5 [e.g. SYLK, DBF,
DIF, etc] the character set choices are reduced.)
Best wishes,
Beatrice Beaubien, Ph.D.
i2eye, Toronto, Canada
Associate, FileMaker Solutions Alliance
FileMaker 7 Certified
On Nov 26, 2006, at 08:55:35, Rowland Carson wrote:
I'm trying to find the right combination of character sets to
ensure correct display of accented, scandinavian, and other
characters outside the plain vanilla ASCII set, in both FMP and in
a web browser view of a MySQL database which is maintained by FMP
text exports.
It looks like a UTF-8 text file provides the correct answer when
it's uploaded to MySQL and viewed with a browser. However, FMP
(8.0v3 on Mac OS X 10.3.9) doesn't provide that among its text
export options [Windows (ANSI), ASCII (DOS), Macintosh, Unicode
(UTF-16), Japanese (Shift-JIS)]. I've achieved the desired result
by opening the Mac option text file with TextWrangler and re-saving
it as UTF-8. However, that's a step I want to eliminate if
possible, especially as this will later need to work on Windows too.
If I try to use a MySQL LOAD DATA INFILE statement on an uploaded
ANSI, DOS or Mac format test file, it appears to discard any
accented characters in a field, and all subequent characters, until
the next field marker (tab). The UTF-16 option text file causes it
to choke at the first character.
Any suggestions or pointers to references are welcome.
regards
Rowland
--
| Wilma & Rowland Carson http://home.clara.net/rowil/
| <[EMAIL PROTECTED]> ... that's Rowland with a 'w' ...
