Hugo wrote:
Richard,
I have to import data from a CSV file with the pgsql COPY command, I just
know that this file comes from an old program written in Clipper (or
something like under linux) , my database was created with UTF8, I cant
find how to create it with UTF-16 on windows, what is the recomended
encoding for Postgres on windows spanish version.
Postgresql only supports UTF-8. If it's just Spanish data, you might be
using one of ISO-8859-1 or ISO 8859-15 (mostly the same as -1 but with
the Euro). These are also known as Latin1 and Latin9. See link below for
a list of various character-sets available.
http://www.jbrowse.com/text/charsets.html
Alternatively, it might be in some Windows-specific character set, if
that's where the file came from. On Linux you should be able to use the
"file" utility to identify the character-set of some text.
Make yourself a coffee and sit down and read the "localization" section
of the manuals, Make sure you understand the difference between server
and client encodings and you might find the bit on conversions useful too.
--
Richard Huxton
Archonet Ltd
