Hi, I am having problems importing sql files containing WAVE DASH or MINUS character :
WARNING: ignoring unconvertible UTF-8 character 0xe3809c WARNING: ignoring unconvertible UTF-8 character 0xe28892 The data contains japanese characters and is imported correctly apart from these two. It seems that postgres is filtering out these characters during import, resulting in incorrect data. I have isolated a small (<1kb) testcase for the wavedash, www.domek.be/testwavedash.sql. Note that the sql files are produced using postgis' shp2pgsql tool from ESRI shape files. The database is setup using EUC_JP encoding. Regards Jorg ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
