Re: [ADMIN] "UNICODE" error during restoration

2006-06-22 Thread Thusitha Kodikara
Thanks Ivo.Ivo Rossacher <[EMAIL PROTECTED]> wrote: In the HISTORY file comming with the source code there are several modifications noted related to characterset handling in general and to unicode more specificaly in the versions before and 7.4.13 it self. The bottom line is that postgresql in ear

Re: [ADMIN] "UNICODE" error during restoration

2006-06-21 Thread Ivo Rossacher
In the HISTORY file comming with the source code there are several modifications noted related to characterset handling in general and to unicode more specificaly in the versions before and 7.4.13 it self. The bottom line is that postgresql in earlier versions did allow incorrect UNICODE sequen

Re: [ADMIN] "UNICODE" error during restoration

2006-06-21 Thread Thusitha Kodikara
Hello,We did some more testing and managed to get the dump restored on 7.4.10. Then took a backup and tried to restore on to 7.4.13, but if failed again giving the same errors.In addition to this we took a dump of an existing DB on 7.4.13 and tried to restore it onto 7.4.13 itself. This also failed

[ADMIN] "UNICODE" error during restoration

2006-06-19 Thread TK
Hi,We took a dump of a database running PostgreSQL 7.3.10 (on Gentoo Linux).We tried to restore it onto a server running PostgreSQL 7.4.13 (on Gentoo Linux). This resulted in the following errors:psql::13856: ERROR:  invalid byte sequence for encoding "UNICODE": 0x85psql::537916: ERROR:  invali

Re: [ADMIN] unicode

2005-06-30 Thread Hannes Dorbath
After 7 hours of trail an error I upgraded FreeBSD from 5.3 to 5.4 - and all of sudden - everything works :) On 30.06.2005 15:57, Tom Lane wrote: We've seen that happen before. As far as I can see it indicates breakage in the locale library: setlocale(LC_MESSAGES, "") should work, but it's fai

Re: [ADMIN] unicode

2005-06-30 Thread Tom Lane
Hannes Dorbath <[EMAIL PROTECTED]> writes: >> I hear that FreeBSD doesn't support Unicode, so you're probably out of luck >> for now. > Hm, but the locales are there, it's just named de_DE.UTF-8 instead of > de_DE.utf8 on FreeBSD. InitDB crashs with the following: > creating template1 database

Re: [ADMIN] unicode

2005-06-30 Thread Hannes Dorbath
I hear that FreeBSD doesn't support Unicode, so you're probably out of luck for now. Hm, but the locales are there, it's just named de_DE.UTF-8 instead of de_DE.utf8 on FreeBSD. InitDB crashs with the following: [EMAIL PROTECTED] pgsql]$initdb --locale=de_DE.UTF-8 The files belonging to this

Re: [ADMIN] unicode

2005-06-30 Thread Peter Eisentraut
Am Donnerstag, 30. Juni 2005 11:58 schrieb Hannes Dorbath: > Thanks. This works fine on Linux, but I could't get it to work on > FreeBSD 5.3 - any ideas? I hear that FreeBSD doesn't support Unicode, so you're probably out of luck for now. -- Peter Eisentraut http://developer.postgresql.org/~pet

Re: [ADMIN] unicode

2005-06-30 Thread Hannes Dorbath
Thanks. This works fine on Linux, but I could't get it to work on FreeBSD 5.3 - any ideas? On 24.06.2005 16:55, Peter Eisentraut wrote: Use initdb --locale=de_DE.utf8 and that should be all. ---(end of broadcast)--- TIP 7: don't forget to incr

Re: [ADMIN] unicode

2005-06-24 Thread Peter Eisentraut
Am Freitag, 24. Juni 2005 11:47 schrieb Hannes Dorbath: > can someone summarize the steps necessary to get PG8 fully setup for > UTF-8 use, please? Locale, initDB params? Especially that SQL functions > like UPPER, LOWER, LENGTH etc work correct as well.. Use initdb --locale=de_DE.utf8 and that sh

[ADMIN] unicode

2005-06-24 Thread Hannes Dorbath
Hi, can someone summarize the steps necessary to get PG8 fully setup for UTF-8 use, please? Locale, initDB params? Especially that SQL functions like UPPER, LOWER, LENGTH etc work correct as well.. Thanks in Advance ---(end of broadcast)--- TIP

[ADMIN] UNICODE issues with postgres

2005-05-27 Thread Dani Oderbolz
Hi there, I am using the groupware product egroupware. When importing German Holidays (containing loads of umlauts), I get this error: "ERROR: Unicode characters greater than or equal to 0x1 are not supported" What caracter set would you recommend (we are using german language only). Than

Re: [ADMIN] Unicode!

2005-03-12 Thread Chen Shaopeng
Since you used Java JDBC to insert the data into PostgreSQL, can you also JDBC to pull it out back and see if you get the right data back? If not, then your database encoding is probably the error. You need to set the DB encoding properly. If you can get your data back to the correct encoding, the

Re: [ADMIN] Unicode!

2005-03-10 Thread Miroslav Šulc
First, I would try to set encoding (charset) for the insert.htm page to UTF-8. That might help. If not, let us know. Miroslav Åulc star star wrote: I use PostgreSQL 8! I have 2 file: insert.htm Untitled Document postgre_insert.jsp <%@ page contentType="text/html; charset=utf-8" import=

[ADMIN] Unicode!

2005-03-10 Thread star star
I use PostgreSQL 8! I have 2 file:   insert.htmUntitled Document      postgre_insert.jsp<%@ page  contentType="text/html; charset=utf-8" import="java.sql.*" errorPage="" %><%  String username=request.getParameter("username"); String str="insert into user_table values('"+username+"','try')";  Clas

Re: [ADMIN] UNICODE -> SJIS problem

2002-12-11 Thread CoL
pg_client_encoding ? Did you set to unicode ? C. Jefim Matskin wrote: I'm trying to develop an international app that will work for the far east = countries too. Working with the PostgreSQL 7.3 and have created a database with the Unicod= e encoding (createdb -E unicode ...) I have an external da

Re: [ADMIN] UNICODE -> SJIS problem

2002-12-10 Thread Peter Eisentraut
Jefim Matskin writes: > I have an external data source that holds some japaneese data in the > UTF-8 encoding. I'm managing to read this data source and insert the > data into my postgres database. The troubles start when I'm try to > display the data using SJIS client encoding. The data is retur

[ADMIN] UNICODE -> SJIS problem

2002-12-10 Thread Jefim Matskin
I'm trying to develop an international app that will work for the far east countries too. Working with the PostgreSQL 7.3 and have created a database with the Unicode encoding (createdb -E unicode ...) I have an external data source that holds some japaneese data in the UTF-8 encoding. I'm mana

[ADMIN] UNICODE 2.x and UTF-8 Support

2000-02-02 Thread R. K. Street
I have been reading in the doc directory of the 6.5.1 tree for information about UNICODE and UTF-8 support and still have a few questions. It is not clear to me whether Unicode 2.x and utf-8 or UCS-2 encodings are available and working okay at this time. Can anyone explain? I get the impressio

[ADMIN] UNICODE 2.x and UTF-8 Support

2000-02-02 Thread R. K Street
It is not clear to me whether Unicode 2.x and utf-8 or UCS-2 encodings are available and working okay at this time. Can anyone explain? I get the impression that UTF-8 is available for the backend but not the frontend. I also get the impression that only ISO 8895-1 through 5 so far work. If