Charset `US-ASCII' not supported,

Squiz Matrix Installation
1

I am fooling around with MSM currently at home on my Linux box and I am having problems with the postgres side of it.


Running Ubuntu Gusty Gibbon. 7.10

Postgres 8.2

Mysource Matrix 3-18-0 RC1

PHP 5.2.3-1ubuntu6.3 (cli)



I have created the databases, and in fact have created quite a few, just getting the hang of it.



The mysource_matrix DB appears "broken" with some warnings turning up when I look at the database in phppgadmin.



It appears to be referring to the fact that the Mysource_matrix DB is in SQL_ASCI.



The other "experimental" Databases I created all work well, as I didnt use the -E SQL_ASCII

command when I created them. They are UTF8



=============================================

>>$ createdb -U postgres -O matrix -E SQL_ASCII mysource_matrix

=============================================



Heres what I get from phppgadmin:



Warning: htmlspecialchars() [function.htmlspecialchars]: charset `US-ASCII' not supported, assuming iso-8859-1 in /usr/share/phppgadmin/libraries/lib.inc.php on line 224



Warning: Cannot modify header information - headers already sent by (output started at /usr/share/phppgadmin/libraries/lib.inc.php:224) in /usr/share/phppgadmin/classes/Misc.php on line 359



Any ideas where I have gone wrong, or could these results be an artifact of the phppgadmin install?

I hope its alright to ask these questions.



Cheers



jeff

==================

Ubuntu Gusty Gibbon. 7.10

Postgres 8.2

Mysource Matrix 3-18-0 RC1

PHP 5.2.3-1ubuntu6.3 (cli)

2

This appears to be an issue with phpPgAdmin, not your database. (Note that the “SQL_ASCII” database encoding is little relation to the US-ASCII encoding seen in the error - this might have been phpPgAdmin using US-ASCII as the equivalent encoding in PHP, rather than, say, ISO-8859-1.) If you aren’t seeing any errors of the same ilk with MySource Matrix, then you should be fine.


Although we can’t support phpPgAdmin obviously, you might try updating to the latest version (4.1.3) if you haven’t got that version already, as it is said that that might address your issue.

3

[quote]This appears to be an issue with phpPgAdmin, not your database. (Note that the “SQL_ASCII” database encoding is little relation to the US-ASCII encoding seen in the error - this might have been phpPgAdmin using US-ASCII as the equivalent encoding in PHP, rather than, say, ISO-8859-1.) If you aren’t seeing any errors of the same ilk with MySource Matrix, then you should be fine.


Although we can’t support phpPgAdmin obviously, you might try updating to the latest version (4.1.3) if you haven’t got that version already, as it is said that that might address your issue.[/quote]



Ok, Thanks for the quick response Luke.

I should have gone to sourceforge first.

Thanks for the link.

Cheers

Jeff