Re: One last question

Rich Shepard writes:
 >    I tried dumping all the records, deleting the db and recreating it before
 > restoring the records. Postgres still sees both refdb and scirefs as UTF8.


How did you check the encoding? I just ran the following on my box:

refdba: createdb -E ISO-8859-1 latin
235:latin
999:1 created:0 failed
refdba: adduser -d latin markus
238:markus@:latin
999:1 added:0 failed
refdba: createdb -E UTF-8 utf
235:utf
999:1 created:0 failed
refdba: adduser -d utf markus
238:markus@:utf
999:1 added:0 failed


That is, now I've got two databases, the first one intended to use
Latin-1 and the second one UTF-8.

Running whichdb on these databases gives:

refdbc: whichdb
Current database: latin
Number of references: 0
Highest reference ID: 0
Number of notes: 0
Highest note ID: 0
Encoding: ISO-8859-1
Database type: risx
Database version: 2
Database server: pgsql
Created: 2006-06-19 19:41:19 UTC
Using refdb version: 0.9.7-pre7
Last modified: 2006-06-19 19:41:19 UTC

refdbc: whichdb
Current database: utf
Number of references: 0
Highest reference ID: 0
Number of notes: 0
Highest note ID: 0
Encoding: UTF-8
Database type: risx
Database version: 2
Database server: pgsql
Created: 2006-06-19 19:43:00 UTC
Using refdb version: 0.9.7-pre7
Last modified: 2006-06-19 19:43:00 UTC

I also checked the databases using the PostgreSQL command line client with
the following queries:

latin=> select encoding from pg_database where datname='latin';
 encoding 
----------
        8
(1 row)

latin=> select encoding from pg_database where datname='utf';
 encoding 
----------
        6
(1 row)


I'd have to look up in the headers what '8' and '6' stand for, but at
least they're different.

So unfortunately I can't reproduce this problem on my box. Did anyone
else try?

regards,
Markus

-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de