Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter Project - Resources

16 bytes added, 11:29, 24 November 2010
PostgreSQL Specifications
: postgre [http://sql-info.de/postgresql/postgres-gotchas.html gotchas]
* Localization: Character set support -::The character set support in PostgreSQL allows you to store text in a variety of character sets (also called encodings), including single-byte character sets such as the ISO 8859 series and multiple-byte character sets such as EUC (Extended Unix Code), UTF-8, and Mule internal code. All supported character sets can be used transparently by clients, but a few are not supported for use within the server (that is, as a server-side encoding). The default character set is selected while initializing your PostgreSQL database cluster using initdb. It can be overridden when you create a database, so you can have multiple databases each with a different character set. An important restriction, however, is that each database's character set must be compatible with the database's LC_CTYPE (character classification) and LC_COLLATE (string sort order) locale settings. For C or POSIX locale, any character set is allowed, but for other locales there is only one character set that will work correctly. (On Windows, however, UTF-8 encoding can be used with any locale.) Note! Not all client APIs support all the listed character sets. For example, the PostgreSQL JDBC driver does not support MULE_INTERNAL, LATIN6, LATIN8, and LATIN10. [http://www.postgresql.org/docs/current/static/multibyte.html]
* BLOBs [http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html]
*some data type setups for postgreSQL driver @ [http://jdbc.postgresql.org/documentation/80/connect.html jdbc.postgresql.org ]
1
edit