Re: django and unicode

2011-10-12 Thread Elim Qiu
Thanks refreegrata. I know PostgreSQL is a good RDBMS, but tough on encoding... I'll start django with MySQL. By doing this, mysql shell cannot do much data manipulation already... In php, utf8 tables is not enough. Every time connect to mysql database, you need to say mysql_query("SET character_

Re: django and unicode

2011-10-12 Thread refreegrata
For example in PostgreSQL, at least from the 8.3 version, you can't have, in the same server, databases with differents encoding. But can be defined a client_encoding for any database. With this you can have a database with encoding='latin1' and client_encoding='utf8'. In postgresql the client_enco

Re: django and unicode

2011-10-11 Thread Elim Qiu
Elim Qiu wrote: >> I just start try django 1.3.1, still in the step I of the tutorial, >> but noticed that the tables created is in latin1 encoding while I >> prefer utf8 for the entire app. > > This https://docs.djangoproject.com/en/dev/ref/unicode/ > > would suggest that making the table UTF8 s

Re: django and unicode

2011-10-11 Thread Lachlan Musicman
On Wed, Oct 12, 2011 at 15:13, Elim Qiu wrote: > I just start try django 1.3.1, still in the step I of the tutorial, > but noticed that the tables created is in latin1 encoding while I > prefer utf8 for the entire app. This https://docs.djangoproject.com/en/dev/ref/unicode/ would suggest that ma

django and unicode

2011-10-11 Thread Elim Qiu
I just start try django 1.3.1, still in the step I of the tutorial, but noticed that the tables created is in latin1 encoding while I prefer utf8 for the entire app. I don't want to set the database default char encoding to be utf8 since I have other non-django apps. What is the proper way of set