Hi Jonathan, I've done some research on your inability to create the fossology database with SQL_ASCII encoding. According to the PostgreSQL documentation, SQL_ASCII encoding is supported when the database character set is compatible with the server's locale setting.(http://www.postgresql.org/docs/8.3/interactive/multibyte.html)
From the PostgreSQL documentation page on Locale Support (http://www.postgresql.org/docs/8.3/interactive/locale.html): Locale support is automatically initialized when a database cluster is created using initdb. initdb will initialize the database cluster with the locale setting of its execution environment by default, so if your system is already set to use the locale that you want in your database cluster then there is nothing else you need to do. If you want to use a different locale (or you are not sure which locale your system is set to), you can instruct initdb exactly which locale to use by specifying the --locale option. What locale is your system set to? (Try examining the LANG or LC_ALL environment variables). Also, you might want to try recreating your database cluster using the --locale option. After you have done that, see if you can create a test database with SQL_ASCII encoding. Good Luck! I hope this helps. Mary ________________________________ From: Jonathan Parès [mailto:[email protected]] Sent: Monday, August 10, 2009 8:48 PM To: Laser, Mary Cc: [email protected] Subject: Re: [FOSSology] Fossology installation troubles : ERROR: Unable to initialize. Dear Mary, I have read this in the Postegresql wiki page of the French Ubuntu community about the release 8.3 : "Il est important de remarquer que lors de l'installation, les bases de données sont créées en unicode et qu'à cause de cela, il ne sera pas possible de créer une base de données dans un autre encodage." that means in English : "It's important to notice that during the installation, the database schemes are created with the unicode encoding and due to this, it will not possible to create an other scheme with an other encoding." Best regards, Jonathan
_______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
