[RESOLVED] special character encoding problem

[unomateo]

I'm parsing an rss feed and inserting all the data into a database.

I'm having trouble with symbols and special characters.

for example the TM (trademark) symbol gets inserted as ’

I then do a select statement from the database and the output is ’

how do I fix this either on the insert or the output...preferably format the symbols on the insert.

[dewen]

make sure the char encoding type from RSS(usually UTF8 or ISO-8859-x) matchs output encoding in your code

[unomateo]

Can I get a small example?

where can I learn more about encoding functions?

[unomateo]

resolved

I used

mb_convert_encoding($cat,'HTML-ENTITIES', 'UTF-8');

on the insert statment and it worked

[MarkR]

If you use the DOM XML parser, as it is clearly documented, everything is ASSUMED TO BE IN UTF-8.

If you need it in another encoding, you'll need to convert it, however, not all characters may be able to be represented in your encoding, in which case you'll end up with data loss.

Mark