Friday 26 March 2004 2:55:11 am
Hi, I'm currently working on a site that uses Chinese and English content on Postgresql. Everything was going fine, but now I wanted to copy the database to a new one. So, I created a new UNICODE database and wanted to input the SQL dump, but got many weird errors. It seems that the database that I used so far was "SQL_ASCII" and not UNICODE how I normally do it. No problems showed and Chinese characters were working. But I can't use the dump to create a new UNICODE database. Does anyone have any suggestions? I want to dump my old database (SQL_ASCII) and input the contents into the new database (UNICODE), but get many "invalid Unicode" errors. Any help appreciated! Kai
|