[thelist] CF: Entity Annoyances! Baffled!

[Jeff Howden]

Frank,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Frank [mailto:lists at frankmarion.com] 
> 
> It's an interesting idea, but it didn't work. The
> bottleneck seems to be made in query phase. It's good in
> the DB, it's good if I paste the char directly in the
> script somewhere, but when it gets pulled from the DB
> to what is output it seems go wonky. Other ideas?
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

A little googling (http://www.google.com/search?q=mysql+latin1+encoding)
turned up some interesting information.

http://bugs.mysql.com/bug.php?id=7756

It would seem that MySQL previous to version 4.1 has difficulty handling
extended ASCII.  Perhaps the character conversion is failing in the
conversation between the DB and the DB driver.  Perhaps if you can upgrade
to 4.1+ you can change from Latin1 to UTF-8 which will give you support for
a broader character set.

 [>] Jeff Howden
     jeff at jeffhowden.com
     http://jeffhowden.com/