Re: [GENERAL] change encoding

Hi Martijn, Thank you very much for reply. It has worked perfectly. Have a good life, All beings be happy Martijn van Oosterhout escribió: On Tue, May 13, 2008 at 05:37:27PM +0200, J. Manuel Velasco - UBILIBET wrote: I have the idea to create the database and the role and then

Re: [GENERAL] change encoding

On Tue, May 13, 2008 at 05:37:27PM +0200, J. Manuel Velasco - UBILIBET wrote: > I have the idea to create the database and the role and then load the > pg_dump result from the other database. The old databse has encoding > LATIN2 so I try to create with this encoding and I get the message(*): > E

Re: [GENERAL] change encoding

Hello, Thanks for your quick replay, but I had other thing to do and I haven't could check your hint before. I started a new postgresql-8-3 installation. Set it up, ok I have the idea to create the database and the role and then load the pg_dump result from the other database. The old databs

Re: [GENERAL] change encoding

On Tue, May 13, 2008 at 09:00:49AM +0200, J. Manuel Velasco - UBILIBET wrote: > Hello, > > I have installed a new postgresql server and I need to recover an old > database on it. > The database I have to recover has LATIN2 as encoding and when i try to > restore it into the new one I get error m

[GENERAL] change encoding

Hello, I have installed a new postgresql server and I need to recover an old database on it. The database I have to recover has LATIN2 as encoding and when i try to restore it into the new one I get error messages due to encoding. I have read that from pgsql8-3 is not possible to have differe

Re: [GENERAL] change encoding ?

Hello, there is no possibility change encoding after database is created. You can only change dynamic encoding for clients, example: czech environment use cp1250 for win clients and latin2 for others clients generally. I init in initdb databse for latin2 encoding. If some people goes from lati

[GENERAL] change encoding ?

hi, how to change encding of already created database wo win-1251 ? tia ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] Change encoding of SQL_ASCII database with multibyte chars?

Hello, there! I recently migrated a medium-sized db from SQL Server to postgres. A couple months after the migration, I noticed I was having some problems retrieving some data via the JDBC driver. The problem turned out to be multi-byte characters (smart quotes, etc) in the SQL_ASCII database.