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