Обсуждение: Fwd: Unicode, RedHat Linux, & PostgreSQL
Anyone? ------- Forwarded message ------- From: Vernon <vernonw@gatewaytech.com> To: pgsql-general@postgresql.org Subject: Unicode, RedHat Linux, & PostgreSQL Date: Wed, 23 Apr 2003 21:18:23 -0700 > > My project works on Window 2000, but not on Linux. The non-Western > language, Chinese in this case, doesn't stored or/and retrieved properly > in Linux. That differenc between the two configurations is only where > PostgreSQL is setting: Window 2000 with Chinese locales, Redhat Linux > 8.0. Does someone have a similar configuration and is able to have non- > Western language stored and retrieved in PostgreSQL 7.2? > > Thanks for your input. > -- Vernon
Hi Vernon, I do not know about the Chinese, but I am using pg 7.3.1 + RH 7.3 and cyrillic and do not have problems with storing data. My linux (server) setting is as default (US). By db creating, I define it as unicode and it is working for me. You will have problems only with sorting. Is is very slow for unicode. regards, ivan. Vernon wrote: > Anyone? > > ------- Forwarded message ------- > From: Vernon <vernonw@gatewaytech.com> > To: pgsql-general@postgresql.org > Subject: Unicode, RedHat Linux, & PostgreSQL > Date: Wed, 23 Apr 2003 21:18:23 -0700 > > > > > My project works on Window 2000, but not on Linux. The non-Western > > language, Chinese in this case, doesn't stored or/and retrieved properly > > in Linux. That differenc between the two configurations is only where > > PostgreSQL is setting: Window 2000 with Chinese locales, Redhat Linux > > 8.0. Does someone have a similar configuration and is able to have non- > > Western language stored and retrieved in PostgreSQL 7.2? > > > > Thanks for your input. > > > > -- > Vernon > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
Hi, Ivan, Thanks for your input. Is the "EUC_JP" for the output of the command "select pg_encoding_to_char(1)"? And what are the string encoding for user input data and data retrieved from DB? What is your programming language? Vernon On Fri, 25 Apr 2003 12:46:33 +0200, pginfo <pginfo@t1.unisoftbg.com> wrote: > Hi Vernon, > > I do not know about the Chinese, but I am using pg 7.3.1 + RH 7.3 and > cyrillic > and do not have > problems with storing data. > > My linux (server) setting is as default (US). > By db creating, I define it as unicode and it is working for me. > > You will have problems only with sorting. Is is very slow for unicode. > > regards, > ivan. > > Vernon wrote: > >> Anyone? >> >> ------- Forwarded message ------- >> From: Vernon <vernonw@gatewaytech.com> >> To: pgsql-general@postgresql.org >> Subject: Unicode, RedHat Linux, & PostgreSQL >> Date: Wed, 23 Apr 2003 21:18:23 -0700 >> >> > >> > My project works on Window 2000, but not on Linux. The non-Western >> > language, Chinese in this case, doesn't stored or/and retrieved >> properly >> > in Linux. That differenc between the two configurations is only where >> > PostgreSQL is setting: Window 2000 with Chinese locales, Redhat Linux >> > 8.0. Does someone have a similar configuration and is able to have >> non- >> > Western language stored and retrieved in PostgreSQL 7.2? >> > >> > Thanks for your input. >> > >> >> -- >> Vernon >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org > > > > -- Vernon
Vernon, The language doesn't matter when using CJK (Chinese/Japanese/Korean) data. The important issue is encoding. All language specific processing is best done in your own custom functions or in the calling program. In my experience locales can be messy and cause problems, unless you only use a single language and encoding for everything. Probably the best encoding to use is UTF-8. If your data is in real unicode, you need to convert it to UTF-8. The problem with unicode and most legacy systems is that there can be 0x00 bytes within the data. UTF-8 doesn't have this problem. Be aware that your programming environment (java for example) or OS could have a slightly modified version of Unicode/UTF-8, so you need to take that into consideration when transfering data between systems. As far as I know, only the 0x00 is processed differently. You need to check this out for your specific environments. I hope that helps. Troy > > Anyone? > > ------- Forwarded message ------- > From: Vernon <vernonw@gatewaytech.com> > To: pgsql-general@postgresql.org > Subject: Unicode, RedHat Linux, & PostgreSQL > Date: Wed, 23 Apr 2003 21:18:23 -0700 > > > > > My project works on Window 2000, but not on Linux. The non-Western > > language, Chinese in this case, doesn't stored or/and retrieved properly > > in Linux. That differenc between the two configurations is only where > > PostgreSQL is setting: Window 2000 with Chinese locales, Redhat Linux > > 8.0. Does someone have a similar configuration and is able to have non- > > Western language stored and retrieved in PostgreSQL 7.2? > > > > Thanks for your input. > > > > > > -- > Vernon > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >