Problems with character encoding

[aangel]

Hi, when I transfer a mysql database dump file from OS X to a Windows NT box, special characters like bullets etc. turn into strange accented characters like ’, etc.

The file was exported as UTF8 and loading it in Smultron (text editor) displays the characters with no problem.

But then transferring them to NT produces the strange characters. I'm using TextEdit++ to view the file on NT and it's set to UTF for the character set.

I've tried transferring the file using both binary and ASCII mode, same result.

Is Yummy doing some sort of encoding here, perhaps?

Thanks,
Andre'

[JD]

The encoding setting in Yummy FTP affects only the file (and folder) names, not the contents of them. And certainly, transferring in Binary mode ensures that the raw data of the file is transferred, so the problem must lie elsewhere.

Unfortunately, I'm not sure what to suggest about how to fix the file encoding problem. Maybe convert the file to plain text, unless anyone has anything else?

[aangel]

Thanks, JD. I thought it an outside chance that Yummy FTP had anything to do with it.

[paulc]

Boy this sure sounds like an issue I used to have with older versions of the m$ os. Basically, the Mac (i.e. all applications, i.e. at the os level) recognizes the full 256 character ASCII set... but the other side only recognizes the lower 128 at the OS level. Every application then has their own map for the hi-ascii characters.

Things like bullets, curly quotes and many foreign language currency symbols ARE standard characters... as long as the standard 256 character set is recognized. I've been out of print production for a while now and assumed the m$ OS addressed the issue!

[aangel]

Hi, Paulc.

Well, I'm using an older version of NT....I'm now investigating that as the source of the problem.