Kjell Rilbe wrote:

> > Strings are written to the database using the defined character set,
> > which will be either the default character set defined for the database
> > or, if present, the character set defined for the column they are
> > written to. For string data to be transliterated correctly for both
> > writing and reading, the connection character set must be the same as
> > the destination character set.
>
> I do not fully understand this.
>
> It sounds as if I have a column with e.g. UTF8, then I must connect with
> UTF8 for transliteration to work correctly.

I agree that particular paragraph does seem to imply that, but reading
the rest of the text, it seems that's not the case. Particularly the
answer to the "How does transliteration work?" question implies that as
long as the data you pass over the connection conforms to the
connection's character set, it will be transliterated to whatever
character set is specified for the column.

Personally, I think everybody should use UTF-8 only and be done with it :-)

Dean.