02:postgresql Character Sets

In the use of PostGIS import shapefile file to PostgreSQL database, always prompt string problem, or garbled, tried several kinds of not, so degrees Niang ....

Using the default UTF8, the prompt message is: latin1;unable to convert data value to UTF-8 (Iconv reports "illegal byte sequence") is recommended. Current encoding is "UTF-8". Try "LATIN1" (Western European), or one of the values described at Http://www.postgresql.org/docs/current/static/multibyt E.html.

When using LATIN1, the situation is: can be successfully imported, all Chinese in the case is garbled;

Finally, the use of GBK, the result is still possible, there is no garbled situation;

Found: http://www.postgresql.org/docs/current/static/multibyte.html

PostgreSQL Character Sets

02:postgresql Character Sets