Forum Moderators: coopster

Message Too Old, No Replies

PHP/mysql invalid character

         

WSQuant

6:17 pm on Jun 22, 2005 (gmt 0)

10+ Year Member



Hi,

We are experiencing a problem with displaying text stored in a mysql database. At the end of most of the sentences being out put is a capital E with a carot above it.

(an E with an ^ on top pretty much)

When I look at the database from mysql control center it looks fine, but in vi the character shows up as a?.

Has anyone ever experienced anything like this before. We are a bit stumped on this issue and any help would be appreciated.

Thanks

jatar_k

6:33 pm on Jun 22, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



where was the data entered from?

all of our windows edited files when viewed in vi have ^M at the end of every line

I am guessing this is similar

WSQuant

6:39 pm on Jun 22, 2005 (gmt 0)

10+ Year Member



The data was originally formated in excel.

WSQuant

7:13 pm on Jun 22, 2005 (gmt 0)

10+ Year Member



Hey, we figured it out using a HEX editor, thanks for offering your help anyways.