Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker Pro database. The single quotes are stored in MySQL as ASCII character 155 (an 'O' with a tilde over it). I have tried everything I can think of to replace this with the PHP I use to query the db but I have failed miserably. I have similar problems with all single quotes and double quotes.
I could probably process the text file before loading it into MySQL (replacing the quotes with their HTML special characters) but I'm wondering if there is anything more fundamental I should be doing.
Cheers and any assistance appreciated
kim
I have had a similar problem importing text data from Mac To Linux.
MySql uses ISO character encoding and the Mac (OS 9) uses MacRoman.
I wrote a small filter that converts MacRoman to ISO.
If You use ascii chars < 128 all works fine but ascii char > 128 are mapped in different position so You have to convert them. (eg á é).
Attention: There are few chars ( < 10) of MacRoman set that don't have an equivalent in ISO (eg Apple Symbol 0xf0 quotes 0xd2-0xd5).
Santino
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
