php/mysql problem(question) - GoFuckYourself.com

alex79 · 02-21-2005, 02:33 AM

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 · 02-21-2005, 03:57 AM

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:

Code:

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 · 02-21-2005, 11:30 AM

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 · 02-21-2005, 12:23 PM

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 · 02-21-2005, 12:32 PM

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

02-21-2005, 02:33 AM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	php/mysql problem(question) 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?

02-21-2005, 03:57 AM	#2
Clarion Confirmed User Join Date: Jan 2005 Location: Ontario, OR Posts: 148	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: Code: 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... __________________ Structure Northwest :: the cure for the common code :: AIM: Asatruel \| Yahoo!: Asatruel \| ICQ: 111-638-053

02-21-2005, 12:23 PM	#4
borked Totally Borked Industry Role: Join Date: Feb 2005 Posts: 6,284	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. __________________ For coding work - hit me up on andy // borkedcoder // com (consider figuring out the email as test #1) All models are wrong, but some are useful. George E.P. Box. p202

02-21-2005, 11:30 AM	#3
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	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?

02-21-2005, 12:32 PM	#5
Fuckin Bill Confirmed User Join Date: Feb 2003 Posts: 1,020	Sounds like a character set problem either in the page/server or your browser.