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 m...@lawinegevaar..nl [firebird-support] <firebird-support@yahoogroups.com> escreveu: > > > On 13-02-2020 15:11, 'Martin, Nicole (UK, Yeovil)' > nicole.mar...@baesystems.com [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 > firebird-support-unsubscr...@yahoogroups.com > > See the footer of the emails from this list for more information. > > Mark > -- > Mark Rotteveel > >