[imp] Signature in UTF-8 [solved]

[Daniel A. Ramaley]

On Thursday 07 February 2008 08:33, Micha Kersloot wrote:
>>>>Seems that UTF-8 is working allright in Imp3, but i'm not able to
>>>>use these characters in the signature.
>> Sorry my mistake... It is Imp H3 4.1.5 that i am using.
>
>With help of Jan, i've found out that you also need to set the
>database connection to UTF8 in the horde configuration.

Being a university we have people from many countries using our 
Horde/Imp installation. Though i've not yet heard any complaints, it 
would be good to make the same switch here. What all is involved in 
switching the database encoding?

I'm using PostgreSQL 7.4.19. According to psql the horde database is 
using "SQL_ASCII" encoding. Horde's database connection is configured 
to use "iso-8859-1".

If i wanted to upgrade to UTF-8, it would not be as simple as telling 
Horde to start using "utf-8", would it? I would also have to convert 
the database itself, right?

If the database itself needs to be re-encoded, my thought is to first 
dump the database and edit the "CREATE DATABASE" line to use 
encoding "UNICODE". Then drop the existing horde database, load the 
modified dump in its place, and reconfigure Horde to use utf-8.

Is any conversion of the dump file itself beyond changing the CREATE 
DATABASE encoding necessary? Right now if i perform a dump, the "file" 
utility reports the result as ASCII text. Plain ASCII shouldn't need 
conversion in order to also be valid UTF-8, right?

Does my procedure seem to be on the right track? Is there something i'm 
forgetting?

------------------------------------------------------------------------
Dan Ramaley                            Dial Center 118, Drake University
Network Programmer/Analyst             2407 Carpenter Ave
+1 515 271-4540                        Des Moines IA 50311 USA