Re: specify Postgres encoding as unicode
Hello! Open your pdAdminIII and create a database using UTF-8. For aplication this is setting for your settings.py: DEFAULT_CHARSET = 'utf-8' FILE_CHARSET = 'utf-8' Regards! 2011/5/18 Thin Rhino > Hello, > > I am wondering if it is possible for me to specify the encoding to use for > a postgresql database in the settings.py > > Going through the django documentation I could find how I could specify it > for mysql. (http://docs.djangoproject.com/en/dev/ref/databases/) > > Tried google, but... !! > > My issue is when I try and save a unicode string into the database it is > converted to \u where X is the unicode code points. > Because of this, say a VARCHAR field I need to multiply the required length > by 4, to fit in a unicode string. Hence I need to change the > database encoding to Unicode. Since django auto creates my database, I am > looking for a way to specify the same in the settings.py file. > > Cheers > ThinRhino > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
Re: specify Postgres encoding as unicode
Thanks for your reply, will try it out on my setup :-) Cheers ThinRhino On 18 May 2011 21:26, Ernesto Guevara wrote: > Hello! > Open your pdAdminIII and create a database using UTF-8. > For aplication this is setting for your settings.py: > DEFAULT_CHARSET = 'utf-8' > FILE_CHARSET = 'utf-8' > > Regards! > > > > 2011/5/18 Thin Rhino > >> Hello, >> >> I am wondering if it is possible for me to specify the encoding to use for >> a postgresql database in the settings.py >> >> Going through the django documentation I could find how I could specify it >> for mysql. (http://docs.djangoproject.com/en/dev/ref/databases/) >> >> Tried google, but... !! >> >> My issue is when I try and save a unicode string into the database it is >> converted to \u where X is the unicode code points. >> Because of this, say a VARCHAR field I need to multiply the required >> length by 4, to fit in a unicode string. Hence I need to change the >> database encoding to Unicode. Since django auto creates my database, I am >> looking for a way to specify the same in the settings.py file. >> >> Cheers >> ThinRhino >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To post to this group, send email to django-users@googlegroups.com. >> To unsubscribe from this group, send email to >> django-users+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/django-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
specify Postgres encoding as unicode
Hello, I am wondering if it is possible for me to specify the encoding to use for a postgresql database in the settings.py Going through the django documentation I could find how I could specify it for mysql. (http://docs.djangoproject.com/en/dev/ref/databases/) Tried google, but... !! My issue is when I try and save a unicode string into the database it is converted to \u where X is the unicode code points. Because of this, say a VARCHAR field I need to multiply the required length by 4, to fit in a unicode string. Hence I need to change the database encoding to Unicode. Since django auto creates my database, I am looking for a way to specify the same in the settings.py file. Cheers ThinRhino -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
