I'm pulling some text from a database, which contains some carriage returns. When I put them straight into html, they get interpreted as � . I've tried a bunch of different ways to remove them, but haven't seemed to have any luck.
Any thoughts?
+2
A:
select Replace(myColumn,CHAR(13),'')
Have you tried this? What else have you tried?
Fosco
2010-07-07 16:01:11
If it's also line-feeds, you can check for both with Replace(Replace(myColumn,CHAR(13),''),CHAR(10),'')
Fosco
2010-07-07 16:01:53
Tried this.. still getting the � character.
MetalAdam
2010-07-07 16:17:52
Then it isn't carriage returns or line-feeds. It must be another character, or encoding. I would use the SQL tools to identify that character and get the ordinal value.
Fosco
2010-07-07 16:29:52
+1
A:
Well, if you want to keep the carriage returns, use nl2br otherwise use $val = str_replace(array('\r\n', '\r', '\n'), ' ', $val);
Trefex
2010-07-07 16:01:26
Mhhh all I see is ? in a black box and this could be any character not recognized by my charset. So I'm not sure which character it actually is you're displaying...
Trefex
2010-07-07 16:21:10
That's the character that is being displayed in my web page. If I look at it through the MySQL Browser, the character resembles a backwards P with an extra | attached to the bottom...
MetalAdam
2010-07-07 16:25:33
+2
A:
It sounds like character encoding conflicts. Other previous suggestions are fine for a quick fix, but if you control the data I think you'd be better off figuring out and sticking to a single character set. If you read from a UTF-8 database and include that text on a website, don't tell the browser that you're serving ISO-8859-1 or Windows-1252.
thetaiko
2010-07-07 16:08:23
I don't control the database, just have access to the information. Any suggestions how I would go about determining the character set of the database?
MetalAdam
2010-07-07 16:40:36
value=latin1I've changed my page to:<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />However, still getting the character...
MetalAdam
2010-07-07 17:37:51
You might try and force the browser to render the page using difference charsets - its possible that the data saved in the database is encoded incorrectly.
thetaiko
2010-07-07 17:49:04
Got it. turns out I needed to use utf8_encode on the string. You got me on the right track, though. Thanks!!!
MetalAdam
2010-07-07 17:51:48