On Fri Aug 20 05:10 PM, Wang, Mary Y wrote: > > So my questions are: > (1) What is the best character encoding that would work for most of > those languages that have accent marks? Store data in PostgreSQL as UTF-8 > (2) I assume that I also > need to do some kind of conversion in the front end (PHP) as well. > > I'm running on Linux and Postgres 8.3.8. > If users are submitting the file names using an HTML form, use: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> ... If using some other method, the common encoding in Europe,north america is CP1252, in php you can convert to UTF8 using: mb_convert_encoding($str, 'UTF-8', 'Windows-1252'); http://www.php.net/manual/en/function.mb-convert-encoding.php -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
