Hi Guys, I really need a solution to this one :(
What is the encoding of the database names in the pg_database table? As far as I can tell, each row is saved in the encoding of the database from which it is created? In my application, the actual names change from gobbledygook to proper japanese or russian say, as I change the encoding of the page through each database encoding. How on earth can I display all the names at once? Is it even possible? What if I go: SET CLIENT_ENCODING TO 'UNICODE'; SELECT * FROM pg_database; That doesn't really seem to work that well though... Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
