Обсуждение: Russian characters

Hi all,

Could I have guidelines on how to store and display (generic ?) Russian
characters right, and Spanish as well, for that matter, alongside with nordic
/ latin1 ? Encoding ? Running RH 7.3 + Pg 7.4.1. Is this even possible ?

This would be for a dynamic multi lingual cfml-website with browser admin.

locale -a gives me loads of installed system locales including

ru_RU
ru_RU.koi8r
ru_RU.utf8
russian
ru_UA
ru_UA.utf8

LC_COLLATE and LC_CTYPE are now fi_FI

TIA and BR,

Aarni


--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com

Aarni Ruuhimäki wrote:

>Hi all,
>
>Could I have guidelines on how to store and display (generic ?) Russian
>characters right, and Spanish as well, for that matter, alongside with nordic
>/ latin1 ? Encoding ? Running RH 7.3 + Pg 7.4.1. Is this even possible ?
>
>This would be for a dynamic multi lingual cfml-website with browser admin.
>
>locale -a gives me loads of installed system locales including
>
>ru_RU
>ru_RU.koi8r
>ru_RU.utf8
>russian
>ru_UA
>ru_UA.utf8
>
>LC_COLLATE and LC_CTYPE are now fi_FI
>
>TIA and BR,
>
>Aarni
>
>
>
>
I suggest making the DB UTF-8-encoded.
But last time i checked, tt worked for me even on a LATIN-1 DB, when
storing and retrieving using JDBC.

--
Sincerely,
Reshat.

-------------------------------------------------------------------------------------------
If you see my certificate with this message, you should be able to send me encrypted e-mail.
Please consult your e-mail client for details if you would like to do that.

Aarni Ruuhimäki <aarni.ruuhimaki@kymi.com> writes:

> Hi all,
>
> Could I have guidelines on how to store and display (generic ?)
> Russian characters right, and Spanish as well, for that matter,
> alongside with nordic / latin1 ? Encoding ? Running RH 7.3 + Pg
> 7.4.1. Is this even possible ?

If you want to store multilingual chars you must use some encoding
that supports that, UTF-8 (Unicode) for instance. Displaying those
chars isn't PostgreSQL issue. The client must be correctly configured
(and should support the corresponding encoding) to display those
chars.

Regards,
Manuel.

Thanks Manuel and Reshat,

I re-inited with UTF-8 and it seems to work ok.

I understand that displaying the chars really depends on the client(browser)
and it is not my concern. I bit baffled though, as I played around with
encoding settings in Konqueror, I can see the 'funny' chars also from a
LATIN1 db. But I am happy as long as the db stores and retrieves them right.
So, no probs.

Thanks again.

BR,

Aarni


On Thursday 29 January 2004 06:57, you wrote:
> Aarni Ruuhimäki <aarni.ruuhimaki@kymi.com> writes:
> > Hi all,
> >
> > Could I have guidelines on how to store and display (generic ?)
> > Russian characters right, and Spanish as well, for that matter,
> > alongside with nordic / latin1 ? Encoding ? Running RH 7.3 + Pg
> > 7.4.1. Is this even possible ?
>
> If you want to store multilingual chars you must use some encoding
> that supports that, UTF-8 (Unicode) for instance. Displaying those
> chars isn't PostgreSQL issue. The client must be correctly configured
> (and should support the corresponding encoding) to display those
> chars.
>
> Regards,
> Manuel.

--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com