[Solar-talk] Save data as UTF-8

[Jeff Surgeson]

Hi Paul

> I'm going through some *really* old mail and I don't recall if we
> answered this question.  Are you still having issues with this?
>
> Thanks, sorry for the very long delay on this one.

No problem, I did solve my problem they were not Solar related just "me 
related"

Thanks anyway

> On Jul 24, 2006, at 5:40 AM, Jeff Surgeson wrote:
> > Hi Paul/Rodrigo
> >
> > Following my character problems and by following your advice I have
> > solved my
> > problems of my mysql tables choking on extended MS and other
> > strange char's.
> >
> > I have corrected my meta tags to include proper charset declarations
> > <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
> >
> > Have removed regex validation on clob types, the only other way was
> > to strip
> > extended char's but that would then mess up what the user was
> > inputing.
> >
> > My editor is set up to save as utf-8 etc.
> >
> > Now the mysql accepts the extended characters like the long minus
> > sign and
> > fancy ms word " but when displayed in a web browser if set to utf-8
> > displays
> > a replacement char, a black square with ? and + below it on my
> > Linux box and
> > a blank square on my windows box.  If set to iso-8859-1 it displays
> > the " but
> > a weird char for the long minus.
> >
> > My question is, should I be formatting the user input prior to
> > saving it to db
> > so it is saved as utf-8. Is there a utf-8 encoding function in php
> > to do
> > this? And if so can I use it under Solar without any problems?
> >
> > --
> > Jeff Surgeson
> > _______________________________________________
> > solar-talk mailing list
> > solar-talk at lists.solarphp.com
> > http://mail.killersoft.com/mailman/listinfo/solar-talk
>
> --
>
> Paul M. Jones  <http://paul-m-jones.com>
>
> Solar: Simple Object Library and Application Repository
> for PHP5.   <http://solarphp.com>
>
> Savant: The simple, elegant, and powerful solution for
> templates in PHP.   <http://phpsavant.com>

-- 
Jeff Surgeson / South Africa