Re: submit data from php: error with special character in the posted text

The encoding of the database and the client are not compatible. First of all
you need to select a database encoding which supports all the characters you
require (for example: createdb -EUNICODE testdb). I would recommend unicode
because it can store all possible characters and can be converted in any
client encoding by the server.
If your client does not support the utf8 encoding (this is the internal
representation of unicode in the database) you can specify the correct
encoding for the client by a sql statement (for example: SET
client_encoding=LATIN1;). show client_encoding will display the current
settings. The server will convert then all characters to and from this
encoding for this client. This conversion will increase the load on the
server side. So for high trafic sites it might be an issue to consider.

Best regards
Ivo

Am Donnerstag, 17. März 2005 15:33 schrieb Luciano Naldesi:
> I am using an open source sw for a test forum, but if I insert in my
> message some special character like à,è,ì ... when I submit the topic I get
> the following error message:
> Error in posting
> DEBUG MODE
> UPDATE elca2Forum_posts_text SET post_text = 'la città', bbcode_uid =
> '04e1371840', post_subject = 'prova accentate' WHERE post_id = 14
> Line : 282
> File : functions_post.php
>
> The message are inserted/updated in a posgresql db.
> Any suggestion?
> thanks luciano