[Solar-talk] Save data as UTF-8

[Paul M Jones]

Hi Jeff,

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.


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>