How to preserve characters with accent?

Started by dfxabout 19 years ago3 messagesgeneral
Jump to latest
#1dfx
dfx@dfx.it

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: dfx (#1)
Re: How to preserve characters with accent?

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/

#3marcelo Cortez
jmdc_marcelo@yahoo.com.ar
In reply to: Peter Eisentraut (#2)
Re: How to preserve characters with accent?

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