2008/10/6, Nei <[EMAIL PROTECTED]>: > Olá, criei uma base de dados via plesk, e o mesmo criou com o encode > ASCII, peguei o comando correto: > > createdb --encoding=UNICODE --owner=username databasename > > a pergunta é, preciso recriar a base com o encode correto ou é > possivel somente alterar. >
Normalmente você precisa refazer o initdb. Do manual: http://www.postgresql.org/docs/current/interactive/locale.html "LC_COLLATE and LC_CTYPE settings are determined at initdb time and cannot be changed without repeating initdb." Veja também: http://www.postgresql.org/docs/current/interactive/multibyte.html "An important restriction, however, is that each database character set must be compatible with the server's LC_CTYPE setting. When LC_CTYPE is C or POSIX, any character set is allowed, but for other settings of LC_CTYPE there is only one character set that will work correctly. Since the LC_CTYPE setting is frozen by initdb, the apparent flexibility to use different encodings in different databases of a cluster is more theoretical than real, except when you select C or POSIX locale (thus disabling any real locale awareness)." Veja este artigo do Roberto Mello sobre codificação o porquê utilizar utf8 (implementação do unicode): http://blog.divisiblebyfour.org/search/label/encoding Osvaldo _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
