Hi, This seems more like a postgres problem more than a django one. It would appear that you have data in different charsets (bad idea). What I would do is just dump the data (convert them to utf8 if needed - see iconv) and then restore everything in a utf8 database.
1. pg_dump -U someuser blah >blah.sql; 2. (iconv on blah.sql - maybe review the file for charset and collation definitions) 3. drop database blah; 4. create database blah with encoding 'utf-8'; 5. psql -U someuser blah 6. \i blah.sql Hope this helps and obviously make proper backups before you try this. Good luck On 2/9/06, PythonistL <[EMAIL PROTECTED]> wrote: > > Hi > Because I use non English characters > I used: > ALTER DATABASE `db_name` DEFAULT CHARACTER SET utf8 COLLATE > utf8_general_ci > > but now, when I want to insert some values into the database, I get > the error: > > (1267, "Illegal mix of collations (utf8_general_ci,IMPLICIT) and > (latin1_swedish_ci,COERCIBLE) for operation '='") > > How can I solve that? > Thank you for help > L.B. > >
