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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Aarni Ruuhimäki <aarni.ruuhimaki (AT) kymi (DOT) com> writes:

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.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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 | Megative Tmi | KYMI.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org