converting databases form SQL_ASCII to UTF8
|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
So, as previously noted, there are certain characters that won't load into a UTF8 database from a dump of the SQL_ASCII database.
Here's our problem. We planned on moving databases a few at a time. Problem is, there is a process that pushes data from one database to another. If this process attempts to push data from a SQL_ASCII database to a new UTF8 database and it has one of these characters mentioned above, the process fails.
So, now the question is, is this effort even worth our effort? What is the harm in leaving our databases SQL_ASCII encoded? Thanks for any insights. -- Until later, Geoffrey "I predict future happiness for America if they can prevent the government from wasting the labors of the people under the pretense of taking care of them." - Thomas Jefferson -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]