Thread: Accents for TEXT

Accents for TEXT

From
"Elisabeth Julg"
Date:
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





Re: Accents for TEXT

From
tony
Date:
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


Re: Accents for TEXT

From
"Elisabeth Julg"
Date:
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


Re: Accents for TEXT

From
Jean-Christophe ARNU (JX)
Date:
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" -+-

Re: Accents for TEXT

From
tony
Date:
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


Re: Accents for TEXT

From
tony
Date:
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


Re: Accents for TEXT

From
"Elisabeth Julg"
Date:
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


Re: Accents for TEXT

From
tony
Date:
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


Re: Accents for TEXT

From
"Elisabeth Julg"
Date:
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