Re: [SQL] Caracter é

2005-08-06 Thread Frank Finner
Hi, what encoding do your webpages have, and what encoding does your database have? If both have the same encoding (eg both UTF8 or both Latin1), all should go well, otherwise you will have to adapt encodings before putting form data into the database (and vice versa), eg with utf_encode / utf_

Re: [SQL] [SQL] Caracter é

2005-08-06 Thread PFC
Hello, This is probably a character encoding issue ; try issuing a SET client_encoding TO whatever encoding you're using ; it is possible that your connection through PHP defaults to SQL_ASCII in which "é" is illegal (mine did). Or, check your browser, form etc. encoding to make s

[SQL] Caracter é

2005-08-06 Thread Nicolas Cornu
Hello, I compiled Postgresql 8 on my server and installed it I am trying to insert a string using php and PEAR::DB The string contain: é and this cause $db-query to fail with an Unkown error as error message. If i insert the data using pgAdminIII the string is inserted into the table. I don