Thread: How to preserve characters with accent?

Dear sirs,

I have some fiel name with character with accent (à, ò...) but when I make a
plain backup of schema (file.sql) that characters are converted to strange
sequence of two (or more?) characters.

How I can avoid this?

Thank you in advance.

Domenico

dfx wrote:
> I have some fiel name with character with accent (à, ò...) but when I
> make a plain backup of schema (file.sql) that characters are
> converted to strange sequence of two (or more?) characters.

You need to set your server and client encoding correctly.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Hi there



--- Peter Eisentraut <peter_e@gmx.net> escribió:

> dfx wrote:
> > I have some fiel name with character with accent
> (à, ò...) but when I
> > make a plain backup of schema (file.sql) that
> characters are
> > converted to strange sequence of two (or more?)
> characters.

 This sounds to me unicode character set ..
 best regards
  MDC
>
> You need to set your server and client encoding
> correctly.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>







__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas