pg.ddx.io pgsql-translators@postgresql.org mailing list archive
help / color / mirror / Atom feedlocalization
5+ messages / 4 participants
[nested] [flat]
* localization
@ 2019-06-07 08:18 Yonathan Misgan <yonathanmisgan.4@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Yonathan Misgan @ 2019-06-07 08:18 UTC (permalink / raw)
To: pgsql-translators
Translation is only one aspect of locales. Other localization aspects are
system services. There are many attributes that are needed to define a
country’s cultural conventions. These attributes include besides the
country’s native language, the formatting of the date and time, the
representation of numbers, the symbols for currency, etc. The locale
represents the knowledge needed to support the country’s native attributes.
So my question is how can I handled these locale aspects (date and time,
collation order, currency symbol, numeric symbol, and format ) in
PostgreSQL. Thank you.
--
Regards,
____________________________________
*Yonathan Misgan *
*Assistant Lecturer, @ Debre Tabor University*
*Faculty of Technology*
*Department of Computer Science*
*Studying MSc in Computer Science (in Data and Web Engineering) *
*@ Addis Ababa University*
*E-mail: yonamis@dtu.edu.et <yonamis@dtu.edu.et>*
* yonathanmisgan.4@gmail.com <yonathanmisgan.4@gmail.com>*
*Tel: (+251)-911180185 (mob)*
^ permalink raw reply [nested|flat] 5+ messages in thread
* Localization
@ 2019-06-10 12:29 Yonatan Misgan <yonamis@dtu.edu.et>
2019-06-11 08:34 ` Re: Localization Daniel Gustafsson <daniel@yesql.se>
0 siblings, 1 reply; 5+ messages in thread
From: Yonatan Misgan @ 2019-06-10 12:29 UTC (permalink / raw)
To: pgsql-translators
Translation is only one aspect of locales. Other localization aspects are system services. There are many attributes that are needed to define a country’s cultural conventions. These attributes include besides the country’s native language, the formatting of the date and time, the representation of numbers, the symbols for currency, etc. The locale represents the knowledge needed to support the country’s native attributes. So my question is how can I handled these locale aspects (date and time, collation order, currency symbol, numeric symbol, and format ) in PostgreSQL. Thank you.
--
Regards,
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Localization
2019-06-10 12:29 Localization Yonatan Misgan <yonamis@dtu.edu.et>
@ 2019-06-11 08:34 ` Daniel Gustafsson <daniel@yesql.se>
0 siblings, 0 replies; 5+ messages in thread
From: Daniel Gustafsson @ 2019-06-11 08:34 UTC (permalink / raw)
To: Yonatan Misgan <yonamis@dtu.edu.et>; +Cc: pgsql-translators
> On 10 Jun 2019, at 14:29, Yonatan Misgan <yonamis@dtu.edu.et> wrote:
>
> Translation is only one aspect of locales. Other localization aspects are system services. There are many attributes that are needed to define a country’s cultural conventions. These attributes include besides the country’s native language, the formatting of the date and time, the representation of numbers, the symbols for currency, etc. The locale represents the knowledge needed to support the country’s native attributes. So my question is how can I handled these locale aspects (date and time, collation order, currency symbol, numeric symbol, and format ) in PostgreSQL. Thank you.
If you search for locale in the PostgreSQL documentation you will find good
resources to get started, among them:
https://www.postgresql.org/docs/current/locale.html
Also note that this list is primarily used for discussing translations of the
postgres binaries, for usage questions around locale support pgsql-general or
pgsql-novice might be better suited.
cheers ./daniel
^ permalink raw reply [nested|flat] 5+ messages in thread
* Localization
@ 2019-07-03 06:52 Yonatan Misgan <yonamis@dtu.edu.et>
2019-07-03 13:23 ` Re: Localization Alvaro Herrera <alvherre@2ndquadrant.com>
0 siblings, 1 reply; 5+ messages in thread
From: Yonatan Misgan @ 2019-07-03 06:52 UTC (permalink / raw)
To: pgsql-translators
Translation is only one aspect of locales. Other localization aspects are system services. There are many attributes that are needed to define a country’s cultural conventions. These attributes include besides the country’s native language, the formatting of the date and time, the representation of numbers, the symbols for currency, etc. The locale represents the knowledge needed to support the country’s native attributes. So my question is how can I handled these locale aspects (date and time, collation order, currency symbol, numeric symbol, and format ) in PostgreSQL. Thank you.
--
Regards,
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Localization
2019-07-03 06:52 Localization Yonatan Misgan <yonamis@dtu.edu.et>
@ 2019-07-03 13:23 ` Alvaro Herrera <alvherre@2ndquadrant.com>
0 siblings, 0 replies; 5+ messages in thread
From: Alvaro Herrera @ 2019-07-03 13:23 UTC (permalink / raw)
To: Yonatan Misgan <yonamis@dtu.edu.et>; +Cc: pgsql-translators
On 2019-Jul-03, Yonatan Misgan wrote:
> Translation is only one aspect of locales. Other localization aspects are system services. There are many attributes that are needed to define a country’s cultural conventions. These attributes include besides the country’s native language, the formatting of the date and time, the representation of numbers, the symbols for currency, etc. The locale represents the knowledge needed to support the country’s native attributes. So my question is how can I handled these locale aspects (date and time, collation order, currency symbol, numeric symbol, and format ) in PostgreSQL. Thank you.
There are locale options that change behavior in various places, such as
to_char and other places. Other than that, I don't think we have a good
answer (but we do have very detailed documentation). If you want to
make a stab at writing an answer, we're listening. This means you'll
have to do a lot of research by yourself.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-07-03 13:23 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-06-07 08:18 localization Yonathan Misgan <yonathanmisgan.4@gmail.com>
2019-06-10 12:29 Localization Yonatan Misgan <yonamis@dtu.edu.et>
2019-06-11 08:34 ` Re: Localization Daniel Gustafsson <daniel@yesql.se>
2019-07-03 06:52 Localization Yonatan Misgan <yonamis@dtu.edu.et>
2019-07-03 13:23 ` Re: Localization Alvaro Herrera <alvherre@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox