RE: SOT: Mensaje de PostgreSQL

Explicacion corta:

No te permitira acentos ni caracteres latinos en bacula_db

*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-Soporte PostgreSQL
*-www.jqmicrosistemas.com
*-809-849-8087
*-------------------------------------------------------*

> Date: Tue, 10 Nov 2009 09:57:31 -0500
> From: rperezm(at)uci(dot)cu
> To: pgsql-es-ayuda(at)postgresql(dot)org
> Subject: [pgsql-es-ayuda] SOT: Mensaje de PostgreSQL
>
> Buenos días a todos:
> Quizás esto sea una pregunta tonta pero me ataca la curiosidad. ¿Qué
> significa? ¿Qué implicaciones me puede traer en mi BD?
>
> Database encoding
> The database bacula_db is created to store data using the SQL_ASCII
> encoding. This encoding is defined for 7 bit characters only; the
> meaning of characters with the 8th bit set (non-ASCII characters
> 127-255) is not defined. Consequently, it is not possible for the server
> to convert the data to other encodings.
> If you're storing non-ASCII data in the database, you're strongly
> encouraged to use a proper database encoding representing your locale
> character set to take benefit from the automatic conversion to different
> client encodings when needed. If you store non-ASCII data in an
> SQL_ASCII database, you may encounter weird characters written to or
> read from the database, caused by code conversion problems. This may
> cause you a lot of headache when accessing the database using different
> client programs and drivers.
> For most installations, Unicode (UTF8) encoding will provide the most
> flexible capabilities.
> --
> Saludos
> ReynierPM
> --
> TIP 8: explain analyze es tu amigo

_________________________________________________________________