Thread: Accents for TEXT
Hi, I have problem with french accents like é, è, à .... In my database (coding in LATIN1), I have a field as : CREATE TABLE XX (Comment TEXT); But, accents are transformed as "?" caracter in my HTML page (result of a selection) ! If the field is a VARCHAR(50), it works well ? Configuration : - postgreSQL 7.2 (compile with : --with-java --enable-multibyte=LATIN1 --enable=locale) - Tomcat 4.0.2 - Mandrake 8.1, - jdk1.3.1_02 : URL : jdbc:postgresql://localhost/Smp?charSet=LATIN1. Have an idea wy or a solution ? Thanks, Elisabeth France
On Wed, 2002-03-27 at 15:15, Elisabeth Julg wrote: > But, accents are transformed as "?" caracter in my HTML page (result of a > selection) ! > If the field is a VARCHAR(50), it works well ? > > Configuration : > - postgreSQL 7.2 (compile with > : --with-java --enable-multibyte=LATIN1 --enable=locale) --with-java --enable-multibyte=YES createdb -E LATIN1 name_of_database Cheers Tony Grant (France aussi) -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
Thanks but the option --enable-multibyte=YES isn't possible : ./configure --enable-multibyte=YES : Checking whether to build with multibyte character support... configure: error:: SQL_ASCII, EUC_JP, EUC_CN, EUC_KR, EUC_TW, UNICODE, MULE_INTERNAL, LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, LATIN6, LATIN7, LATIN8, LATIN9, LATIN10, KOI8, WIN, ALT, ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8 Or do not specify an argument to the option to use the default. Elisabeth -----Message d'origine----- De : pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]De la part de tony Envoyé : mercredi 27 mars 2002 15:40 À : elisabeth.julg@steria.com Cc : pgsql-jdbc@postgresql.org Objet : Re: [JDBC] Accents for TEXT On Wed, 2002-03-27 at 15:15, Elisabeth Julg wrote: > But, accents are transformed as "?" caracter in my HTML page (result of a > selection) ! > If the field is a VARCHAR(50), it works well ? > > Configuration : > - postgreSQL 7.2 (compile with > : --with-java --enable-multibyte=LATIN1 --enable=locale) --with-java --enable-multibyte=YES createdb -E LATIN1 name_of_database Cheers Tony Grant (France aussi) -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
Le Wed, 27 Mar 2002 15:15:33 +0100
"Elisabeth Julg" <elisabeth.julg@steria.com> me disait que :
> Hi,
>
> I have problem with french accents like é, è, à ....
>
> In my database (coding in LATIN1), I have a field as :
> CREATE TABLE XX (Comment TEXT);
>
> But, accents are transformed as "?" caracter in my HTML page (result of a
> selection) !
> If the field is a VARCHAR(50), it works well ?
>
> Configuration :
> - postgreSQL 7.2 (compile with
> : --with-java --enable-multibyte=LATIN1 --enable=locale)
> - Tomcat 4.0.2
> - Mandrake 8.1,
> - jdk1.3.1_02 : URL : jdbc:postgresql://localhost/Smp?charSet=LATIN1.
Consider using jdbc:postgresql://localhost/Smp?charSet=ISO-8859-1 instead.
This works with my (French) database
--
Jean-Christophe ARNU
s/w developer
Paratronic France
Question: Comment s'écrit Jacoboni ?
Réponse: Jacoboni, pas Jacobini.
-+- fcol-faq in Guide du linuxien pervers - "Bien configurer son Jaco" -+-
On Wed, 2002-03-27 at 16:05, Elisabeth Julg wrote: > > Thanks but the option --enable-multibyte=YES isn't possible : Sorry!! ./configure --enable-multibyte should do it. I've been compiling Cyrus IMAP... it shows Cheers Tony -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
On Wed, 2002-03-27 at 16:05, Elisabeth Julg wrote: > Checking whether to build with multibyte character support... configure: > error:: > SQL_ASCII, EUC_JP, EUC_CN, EUC_KR, EUC_TW, > UNICODE, MULE_INTERNAL, > LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, > LATIN6, LATIN7, LATIN8, LATIN9, LATIN10, > KOI8, WIN, ALT, > ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8 > Or do not specify an argument to the option to use the default. If you do specify LATIN1 now you won't be able to use the backend with LATIN9 when you want EURO support. It is better to specify the default then enable the encoding when you do createdb (personal opinion). I have a UNICODE database system on one machine and a default on another and, well they don't get along... Cheers Tony -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
Hi, I have try to compile just with --enable-multibyte (without --enable-locale). But I can't start postmaster (cause LC_LOCALE). With --enable-multibyte without --enable-locale, With a database encoded ISO8859-1 (or ISO8859-9) and url ...?charset=ISO8859-1 (or ISO8859-9), I have always the same problem (with the old database or new). If LC_LOCALE (and co). are positionned at fr_FR@euro or not, the result is the same : accents are transfomed in '?' character. Note : It works well with VARCHAR, but not with TEXT field. For Windows system, I have no problem, but in production I need use Mandrake 8.1. Variables LC_LOCALE (and co) are importants ? Sincères salutations, Elisabeth (PS: Je serai en congès demain et la semaine prochaine). -----Message d'origine----- De : pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]De la part de tony Envoyé : mercredi 27 mars 2002 16:10 À : elisabeth.julg@steria.com Cc : pgsql-jdbc@postgresql.org Objet : Re: [JDBC] Accents for TEXT On Wed, 2002-03-27 at 16:05, Elisabeth Julg wrote: > > Thanks but the option --enable-multibyte=YES isn't possible : Sorry!! ./configure --enable-multibyte should do it. I've been compiling Cyrus IMAP... it shows Cheers Tony -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
On Thu, 2002-03-28 at 12:50, Elisabeth Julg wrote: > I have try to compile just with --enable-multibyte > (without --enable-locale). But I can't start postmaster (cause LC_LOCALE). > > With --enable-multibyte without --enable-locale, > With a database encoded ISO8859-1 (or ISO8859-9) and url > ...?charset=ISO8859-1 (or ISO8859-9), I have always the same problem (with > the old database or new). > If LC_LOCALE (and co). are positionned at fr_FR@euro or not, the result is > the same : accents are transfomed in '?' character. > Note : It works well with VARCHAR, but not with TEXT field. For Windows > system, I have no problem, but in production I need use Mandrake 8.1. > > Variables LC_LOCALE (and co) are importants ? Have you tried the rpms? I haven't tried compiling since the excellent people on this list who make rpms included java and multibyte. So I just rpm -Uvh postgresql* And it works. I am having problems with ' in queries wich look for "l'art" etc. But accents work just fine in java, psql, perl you name it they work! > Sincères salutations, How formal... sur les listes cordialement c'est mieux! > (PS: Je serai en congès demain et la semaine prochaine). Il y en a qui ont de la chance... Cheers Tony -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
Hi, I have installed the RPMS 7.2, but I have always the same problem. What is your configuration ? Très Cordialement, Elisabeth -----Message d'origine----- De : tony [mailto:tony@animaproductions.com] Envoyé : jeudi 28 mars 2002 13:00 À : elisabeth.julg@steria.com Cc : pgsql-jdbc@postgresql.org Objet : RE: [JDBC] Accents for TEXT On Thu, 2002-03-28 at 12:50, Elisabeth Julg wrote: > I have try to compile just with --enable-multibyte > (without --enable-locale). But I can't start postmaster (cause LC_LOCALE). > > With --enable-multibyte without --enable-locale, > With a database encoded ISO8859-1 (or ISO8859-9) and url > ...?charset=ISO8859-1 (or ISO8859-9), I have always the same problem (with > the old database or new). > If LC_LOCALE (and co). are positionned at fr_FR@euro or not, the result is > the same : accents are transfomed in '?' character. > Note : It works well with VARCHAR, but not with TEXT field. For Windows > system, I have no problem, but in production I need use Mandrake 8.1. > > Variables LC_LOCALE (and co) are importants ? Have you tried the rpms? I haven't tried compiling since the excellent people on this list who make rpms included java and multibyte. So I just rpm -Uvh postgresql* And it works. I am having problems with ' in queries wich look for "l'art" etc. But accents work just fine in java, psql, perl you name it they work! > Sincères salutations, How formal... sur les listes cordialement c'est mieux! > (PS: Je serai en congès demain et la semaine prochaine). Il y en a qui ont de la chance... Cheers Tony -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html