|
|
| Apr 1, 2004 | Home > Bugzero > FAQs > KB |
The following table lists all the character sets that are available on PostgreSQL databases. The charset can be set on the database system level as well as on the JDBC URL. For the later, the format is: jdbc:postgresql://localhost:5432/bugzero_db?charSet=UNICODE.
| Name | Description |
| SQL_ASCII | ASCII |
| EUC_JP | Japanese EUC |
| EUC_CN | Chinese EUC |
| EUC_KR | Korean EUC |
| JOHAB | Korean EUC (Hangle base) |
| EUC_TW | Taiwan EUC |
| UNICODE | Unicode (UTF-8) |
| MULE_INTERNAL | Mule internal code |
| LATIN1 | ISO 8859-1/ECMA 94 (Latin alphabet no.1) |
| LATIN2 | ISO 8859-2/ECMA 94 (Latin alphabet no.2) |
| LATIN3 | ISO 8859-3/ECMA 94 (Latin alphabet no.3) |
| LATIN4 | ISO 8859-4/ECMA 94 (Latin alphabet no.4) |
| LATIN5 | ISO 8859-9/ECMA 128 (Latin alphabet no.5) |
| LATIN6 | ISO 8859-10/ECMA 144 (Latin alphabet no.6) |
| LATIN7 | ISO 8859-13 (Latin alphabet no.7) |
| LATIN8 | ISO 8859-14 (Latin alphabet no.8) |
| LATIN9 | ISO 8859-15 (Latin alphabet no.9) |
| LATIN10 | ISO 8859-16/ASRO SR 14111 (Latin alphabet no.10) |
| ISO_8859_5 | ISO 8859-5/ECMA 113 (Latin/Cyrillic) |
| ISO_8859_6 | ISO 8859-6/ECMA 114 (Latin/Arabic) |
| ISO_8859_7 | ISO 8859-7/ECMA 118 (Latin/Greek) |
| ISO_8859_8 | ISO 8859-8/ECMA 121 (Latin/Hebrew) |
| KOI8 | KOI8-R(U) |
| WIN | Windows CP1251 |
| ALT | Windows CP866 |
| WIN1256 | Windows CP1256 (Arabic) |
| TCVN | TCVN-5712/Windows CP1258 (Vietnamese) |
| WIN874 | Windows CP874 (Thai) |
* Reference brought to you by Bugzero, it's more than just bug tracking software!