Zitat von "Daniel A. Ramaley" <[EMAIL PROTECTED]>: > 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?
Correct. > 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. These seems to be PostgresQL specific feature, so I can't tell what exactly it does, but it sounds reasonable. > 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? If you are absolutely sure that you only have ASCII data, this is sufficient. But as soon as you have latin1 aka iso-8859-1 characters above 127 inside your data, this no longer works, because those characters are multibyte in utf-8. And this breaks at least in those cases where we store serialized arrays. Jan. -- Do you need professional PHP or Horde consulting? http://horde.org/consulting/ -- IMP mailing list - Join the hunt: http://horde.org/bounties/#imp Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [EMAIL PROTECTED]
