[Mageia-sysadm] postgresql database charset

[Olivier Thauvin]

* Michael Scherer (misc at zarb.org) wrote:
> Hi, while looking at the list of database on alamut, I have seen that
> some of them are in utf8, and some of them are in ascii, shouldn't it be
> better to put everything in utf8 ?
> 
> Can we do the conversion without trouble with dump and reload ?

Changing the encoding is not really a problem, however, some issue can
appear if the application don't check the encoding of the data it want
to store. For instance invalid UTF-8 bytes can be stored in ascii, not
in utf8 database.

So I fear changing encoding may break some tools...

> 
> ( and who is volunteer ? )
> 
> -- 
> Michael Scherer
> 
> _______________________________________________
> Mageia-sysadm mailing list
> Mageia-sysadm at mageia.org
> https://www.mageia.org/mailman/listinfo/mageia-sysadm
-- 

Olivier Thauvin
CNRS  -  LATMOS
♖ ♘ ♗ ♕ ♔ ♗ ♘ ♖
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: </pipermail/mageia-sysadm/attachments/20110221/904a773f/attachment.asc>