On Aug 6, 2009, at 3:59 PM, Christer Nilsson wrote:
> > I'm pushing my app together with a read-only text file containing > swedish characters, åäö. > When starting the app, it reads the file and stores the text in the > database. > > My problem is, the file contains characters not compatible with what > postgresql expects. > > Q1: what character set is postgresql initialized to use at heroku? Heroku uses UTF-8, to do the same locally, you need to set it at initdb time (and it can't be changed dynamically when the database is running)... initdb --locale=en_US.UTF-8 -D /Library/PostgreSQL/8.4/data/ > > > Q2: what character set must the text file have? UTF-8 > > > Q3: Are there different variations of UTF-8 ? nope, but there are different collations which affects equality and sorting Sarah http://www.ultrasaurus.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
