View Single Post
  #2 (permalink)  
Old 04-02-2008, 01:09 PM
Peter H. Coffin
 
Posts: n/a
Default Re: Strange unicode chars in database

On Tue, 1 Apr 2008 17:15:10 -0700 (PDT), Adam_m wrote:
> If I have this in MySQL 5.x
>
> 08/2006 – Created a simulation program with
> Java to simulate the behavior of small networks
>
> How can I decode the UTF8 latin data to render correctly in PHP ?
>
> Better still -- how can I fix the data in MySQL ?


Those are, more importantly, HTML/XML character entities, expressing two
layers of ascii-to-utf8 encoding. So, you've got several places where
data going into the table is being assumed to be some flavor of plain
ascii and being converted into utf8, and that's Not Right. Unless you
fix that problem this will continue to be a recurring problem with your
system forever, with random levels of encoding nesting like rats in the
walls.

--
Is it just me, or is it a clear indication that a thread is ending its
useful life is when people start debating the merits of the analogies
that have been posed rather than the original subject matter of the
thread? --Rhetorical question by Rainer Atkins founding "Atkins' Law"
Reply With Quote