Thread: Urgent help need on French language.
Hi, I have a postgres database running linux platform.The database has been enabled for multibyte support -works fine for Japanese,Spanish,German.But when it comes to French..i am able to insert French data The Problem is when i want displaythe data on the browser, some funny '?' comes along the data.I really don't know what setting need to be done onthe database front. I would appreciate if some one can throw some light on how to solve this problem? Thanks in advance. Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: Sbangalore@zensutra.com 'Weaving the knowledge tapestry'
Le Tue, 31 Dec 2002 14:47:42 +0530 "Somasekhar Bangalore" <sbangalore@zensutra.com> me disait que : > Hi, > > I have a postgres database running linux platform.The database has been > enabled for multibyte support -works fine for Japanese,Spanish,German. But > when it comes to French..i am able to insert French data The Problem is > when i want display the data on the browser, some funny '?' comes along the > data.I really don't know what setting need to be done on the database front. > I would appreciate if some one can throw some light on how to solve this > problem? You should use ISO-8859-1 or ISO-8851-15 encodings to make those characters "displayable" :) It depends on your "front-end". (for java, you only have to specify "?charSet=ISO-8859-15" at the end of the URL to be given to the JDBC driver) Regards -- Jean-Christophe ARNU Wisdom is knowing what to do with what you know. -- J. Winter Smith
For the browser issue, you can switch between charsets with the META tag in the "<head>" section. Exemple : <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> "Jean-Christophe ARNU (JX)" wrote: > Le Tue, 31 Dec 2002 14:47:42 +0530 > "Somasekhar Bangalore" <sbangalore@zensutra.com> me disait que : > > > Hi, > > > > I have a postgres database running linux platform.The database has been > > enabled for multibyte support -works fine for Japanese,Spanish,German. But > > when it comes to French..i am able to insert French data The Problem is > > when i want display the data on the browser, some funny '?' comes along the > > data.I really don't know what setting need to be done on the database front. > > I would appreciate if some one can throw some light on how to solve this > > problem? > > You should use ISO-8859-1 or ISO-8851-15 encodings to make those characters > "displayable" :) > > It depends on your "front-end". (for java, you only have to specify > "?charSet=ISO-8859-15" at the end of the URL to be given to the JDBC driver) > > Regards > > -- > Jean-Christophe ARNU > Wisdom is knowing what to do with what you know. > -- J. Winter Smith > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)