php/mysql problem(question)

[alex79]

i have ' character in my database, but when i make a select and display the content with echo() the ' character is auto replace with ? character..
what i have do to stop this auto replace?

[Clarion]

That's kinda bizarre...does your page have a character set selected?

[HTML]<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />[/HTML]

If that's not it, try inserting it into the database with the function addslashes:

addslashes("This is the string I'm trying to input");

Lastly, if that doesn't work, make sure you're using the standard ascii ' symbol and not some strange variation like word puts in...

[alex79]

i don't have that HTML code on my pages.. and when i've entered the text to the database i used addslashes() function.. now when i select the text from database, i use stripslashes() and echo($text) and instead ' character i get ?

anybody else know what can be?

[borked]

What browser are you using and what character(s) is displaying as ?
?
Have you tried converting symbols to their html counterpart before entering them in the database using htmlentities() ?

For eg, the Euro symbol, depending on the encoding text will displaying incorrectly on Firefox, but will do fine when 'encoded' using htmlentities() for storing.

[Fuckin Bill]

Sounds like a character set problem either in the page/server or your browser.