Dimitry, hi again.
I tried to set the locale on a Firebird super server installation.
I edited the /etc/init.d/firebird service script, and a added this to it:
export LANG="pt_BR.utf8"
Then I reload and restart the service with:
systemctl daemon-reload
systemctl restart firebird
After this, I got the correct locale in the firebird server process, I
query this using:
xargs -r0a "/proc/$PID/environ" sh -c 'exec env -i -- "$@" locale' sh
>>> change the $PID with the PID number of the fbserver
So, after all, I tried to query my UDF function with this:
select format_float(12343.2399, ',0.00') from rdb$database
This "format_float" udf is a lazarus udf that calls the "formatFloat" that
uses the default LC_NUMERIC variables.
So I expected the result:
12.343,24
But I continue to get:
12,343.24
The thousand separator in PT_BR is "," not "." (dot).
The same UDF, installed on a linux PT_BR works, as so on Windows PT_BR
compiled version.
Any idea whats happening?
Em qui., 13 de fev. de 2020 às 12:13, Mark Rotteveel [email protected]
[firebird-support] <[email protected]> escreveu:
>
>
> On 13-02-2020 15:11, 'Martin, Nicole (UK, Yeovil)'
> [email protected] [firebird-support] wrote:
> > I have a feeling I have been added to a group that isn't right as the
> subject doesn't match what I am asking in my email?
>
> This is the firebird-support mailing list for community support for the
> Firebird database system. You didn't ask a question, someone else did
> and you replied to the thread.
>
> As far as I know, it is not possible to subscribe someone else, so you
> should have subscribed yourself at some point.
>
> To unsubscribe, send an email to
> [email protected]
>
> See the footer of the emails from this list for more information.
>
> Mark
> --
> Mark Rotteveel
>
>
