Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: small bug in to_char and TM prefix, in RC



Hello,

after apply my patch this bug is only visible (for czech env). Propably in others languages isn't used diacritic's chars in mont's and days's names. str_toupper is too simply and don't support UTF8, which isn't for english problem.

I prepare patch.

Regards
Pavel Stehule






And this failure is with your translation patch applied?

---------------------------------------------------------------------------

Pavel Stehule wrote:
> Hello,
>
> I tested TM formating with czech names. Upper case chars in name are not
> correct. Function upper works perfectly.
>
> Sample:
>
> postgres=# select to_char(date '2006-02-03', 'TMday');
> to_char
> ---------
> pátek
> (1 řádka)
>
> correct
>
> but
>
> postgres=# select to_char(date '2006-02-03', 'TMDAY');
> to_char
> ---------
> PáTEK
> (1 řádka)
>
> correct is PÁTEK
>
> without spec. chars
> wrong: PaTEK, have be: PATEK
>
> Regards
> Pavel Stehule
>
> _________________________________________________________________
> Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

--
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz/




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group