From: | edmund(at)lillypad(dot)ecclestoad(dot)co(dot)uk |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Storing double-byte strings in text fields. |
Date: | 2001-02-15 16:34:17 |
Message-ID: | 20010215163417.19656.qmail@lillypad.ecclestoad.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am putting together a web site to display a collection of Chinese
woodblock prints. I want to be able to store double byte values (that is
to say Big5, Unicode etc encoded) in a text field for things such as the
artist's name and the title of the print. I have the following questions:
Is this possible using a plain vanilla version of Postgres, ie without the
multi-lingual support enabled? As I understand it multi-lingual support
allows me to store table and field names etc in non-ASCII, but doesn't
really affect what goes into the fields.
Are programs such as pgdump and the COPY method 8bit clean or will they
mess up the text? I have done some quick trials and it all seems OK but I
want to be sure before commiting.
If the above is not the case will the multi-lingual support fix my
problems? I tried it out but had problems with the backend crashing on
certain queries. I'd also rather not use it as it will be easier to port
my system to other servers if it just needs a plain vanilla install.
I am currently using Postgresql 7.0.3 on RedHat 6.2 (x86) and also on
YellowDog 1.2 (PPC). The web server is Apache 1.3.12 with PHP 4.0.x.
Thanks,
Edmund.
-- *********************************************************** *** Edmund von der Burg *** edmund(at)ecclestoad(dot)co(dot)uk *** ***********************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | David Wheeler | 2001-02-15 16:36:43 | Re: Case insensitive selects? |
Previous Message | Bruno Wolff III | 2001-02-15 16:32:56 | Re: regular expression substittion function? |