On Friday 18 December 2009 4:30:46 am Durumdara wrote: > Hi! > > I have a software that uses Postgresql. This program (and website) > developed and working on Window (XP/2003), with native charset (win1250). > > Prior week we got a special request to install this software to a Linux > server. > > Yesterday I installed Ubu9.10 on VirtualBox, and tried to moving the > database under Linux. > > First big problem is that when I tried to create a database with same > parameters as in Windows, the PGAdmin show an error. > The errormessage is: > "Error: new encoding (Win1250) is incompatible with the encoding of the > template database (UTF8)." > > Ok, I changed to "template0". > > Then I got error that Win1250 is not good for collation hu_HU.UTF8. > > When I tried to insert hungarian chars (to check sort order), the C and > POSIX return wrong result - as I thought before. > > The Windows version of PG and Admin is not supports collation, so these two > options are disable (collation, character type). There is a Linux version of PGAdmin available for Ubuntu 9.10. > > But in Linux I have only UTF version that can sort rows in good order. > > The problem that the client program is win1250 based, and I must rewrite > all things to make same results. > > Have anybody some way, some tricky solution for this problem? Use psql and CREATE DATABASE: http://www.postgresql.org/docs/8.4/interactive/sql-createdatabase.html > > Thanks for your help: > dd -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
