You are here: Re: form text é->éé in MySQL « PHP Language « IT news, forums, messages
Re: form text é->éé in MySQL

Posted by Matt White on 04/06/07 12:38

I have had the same problem- insert this code in your header:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

and change your database collation to utf8_bin. Note that you must change
every single column separately. I really hope this helps!

BTW: If your page still catches this as some odd character and outputs the
block character, try using a string replace, change é with &eacute; (in case
that gets parsed, it is a & , followed by the word eacute , with a ; at the
end).

"NRJ" <adsense@nrjansen.nl> wrote in message
news:1175803232.210984.60770@p77g2000hsh.googlegroups.com...
> Thanks for your answer, but I still have the same issue here.
> My webpage says utf-8 and the database is latin1_swedish_ci (don't
> know why).
>
> What is the best collation for my database? Is it best to change it to
> UTF8-Unicode_ci ?
>
> Presumably I'll have to export my data first in order to keep the
> current content in the database.
>
> Thanks
> Niels
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация