Posted by Wim Cossement on 09/07/06 09:00

Hi boys and girls,

I've finally succeded in getting those uncommon UTF-8 chars in my DB.

The solution is in the end always seems rather obvious, but I'd like to
say thanks for pushing me in the good direction.

The thing that did the trick was putting
AddType 'text/html; charset=UTF-8' html
in .htaccess

Sending a PHP header with "Content-type: text/html; charset: utf-8"
resulted in an error message that headers had already been sent.

Now I'm still having a problem with a simple mail function that just
does not want to go, but, that's for later.

See you,

Wimmy

Wim Cossement wrote:
> Hello,
>
> I was wondering if there are a few good pages and/or examples on how to
> process form data correctly for putting it in a MySQL DB.
>
> Since I'm not used to using PHP a lot, I already found out that
> addslashes() can be used escape some characters, but I'm having some
> more problems with for instance ä, å and µ (since the text is scientifical)
> Now some people also throw in htmlspecialchars() to convert those to
> HTML entities, but some nest htmlspecialchars() in addslashes() and
> others do the opposite.
>
> Is there a good and error proof way of ensuring that what one puts in a
> textarea gets stored and can be retrieved safe and sound?
>
> Thanks in advance,
>
> Wimmy
>


--
Being owned by someone used to be called slavery.
Now it's called commitment.

[Back to original message]