| From: | "Nikola Milutinovic" <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu> |
|---|---|
| To: | "PostgreSQL novice" <pgsql-novice(at)postgresql(dot)org>, "PostgreSQL general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | CP1250 to and from Unicode conversion, how? |
| Date: | 2001-10-31 13:37:59 |
| Message-ID: | 005801c16211$41e07640$0a3ea8c0@ev.co.yu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Hi all.
I have a database with text fields containing text with Windows CP-1250 encoding. How can I convert it to Unicode? I have build the database with
--enable-recode enable character set recode support
--enable-multibyte enable multibyte character support
--enable-unicode-conversion enable unicode conversion support
Also, how can I enter a string containing Unicode chars from "psql"? What is the Unicode escape sequence?
I mean, if all else fails, I'll dump database, run the dump through script/Java/C program to convert all CP-1250 chars to their Unicode equivalents and import it again.
Hope someone will answer my question.
Nix.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Meenatchi Anbuchelvan | 2001-10-31 15:02:04 | Re: DOes PostgreSQL support UInt64? |
| Previous Message | tony | 2001-10-31 13:05:16 | function gurus... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | samsom, debra | 2001-10-31 15:47:21 | postgres copy |
| Previous Message | Duncan Adams (DNS) | 2001-10-31 09:58:56 | Re: moving postgres data |