installing postgresql on Debian and need your help...

[stevewabc]

Im trying to install postgresql on Debian and have some ? on the install can you all help? I dont no what this stuff is.

1. what character encoding should the database use by default?
per_locale # │
│ SQL_ASCII ▒ │
│ UNICODE ▒ │
│ EUC_JP ▒ │
│ EUC_CN
EUC_KR ▒ │
│ JOHAB ▒ │
│ EUC_TW # │
│ MULE_INTERNAL ▒ │ │ LATIN1 ▒ │
│ LATIN2 ▒ │
│ LATIN3 ▒ │
│ LATIN4 ▒ │
│ LATIN5 ▒ │
│ LATIN6 ▒ │
│ LATIN7 ▒ │
│ LATIN8
LATIN9 ▒ │
│ LATIN10 ▒ │
│ ISO-8859-5 ▒ │
│ ISO-8859-6 ▒ │
│ ISO-8859-7 ▒ │
│ ISO-8859-8 ▒ │
│ KOI8 ▒ │
│ WIN ▒ │
│ ALT ▒ │
│ WIN1256 ▒ │
│ TCVN ▒ │
│ WIN874 # │
│ │
│

[Ludootje]

I thought normally the defaults are already selected, no?
I don't know the differences between all those, but you might be able to find more information on the PostgreSQL website.

[Syntaxis]

Go for Unicode (also known as UTF8 or UTF-8). It's the way of the future.

From the "What is Unicode?" page at http://www.unicode.org/standard/WhatIsUnicode.html:

---
Unicode provides a unique number for every character, no matter what the platform, no matter what the program, no matter what the language.
---

Basically its goal is to unify charsets into a single locale, which should aid internationalisation no end. Not everything supports it yet, but where it's supported, use it.

[stevewabc]

Thank you all so much:D