where and how i put the lc_time_names parameter?

amiens80 · Post by **amiens80** » Fri May 15, 2020 4:47 pm

hi,

with mysql, we can specify the local names for days by example.
so in mysql query we set the lc_time_names ='FR_fr' to have the name of the days in French instead of english..
i tried to set the parameter in phpmaker, advanced settings, option "Database time zone (for SET TIME ZONE)" .
i enter in the field : lc_time_names ='FR_fr'
but nothing appened, data (like daynname(date) still appears in english language (whereas all the other language setting are fine translated in phpmaker).
do i need a special syntaxe or double quote or other scheme to enter lc_time_names ='FR_fr' ?

i checked the documentation and there is not example of the correct synthaxe we need to enter in phpmaker.

best regards

arbei · Post by **arbei** » Sat May 16, 2020 9:10 am

SET TIME ZONE is used to set time zone, not locale. You may use Database_Connected server event (see the topic Server Events and Client Scripts in help file) to execute SET lc_time_names.

amiens80 · Post by **amiens80** » Tue May 19, 2020 4:45 pm

thank you my Lord, it run fine :

// Database Connected event
function Database_Connected(&$conn) {
	// Example:
	//if ($conn->info["id"] == "DB")
	//	$conn->Execute("Your SQL");
	$conn->execute("SET lc_time_names = 'fr_FR';");
}

By the way, that kind of parameter should be in the language file or region files like in the locale setting fr.json file with other regional parameter....

mpol_ch · Post by **mpol_ch** » Fri Nov 25, 2022 1:55 am

Hi,
I trying to get the day name in german.
My language Id is de-CH and the local setting is also correct and the languate id too.
But I am not getting the german daynumnber.
I am using the following code in a view to get the day name of a datetime field:

Date_Format(f.Start, '%a') AS Tag,

Where to check?

thanks
mpol_ch

mobhar · Post by **mobhar** » Fri Nov 25, 2022 8:09 am

Did you mean you put that code as a part of WHERE clause of your Database View?

mpol_ch · Post by **mpol_ch** » Fri Nov 25, 2022 3:31 pm

No,
It is in a view and between Select and From.
What want to reach is, is to get the day abbrevation in german, hence I am using the german language with id de-CH.
Generally it should do this with
SET lc_time_names = 'de-CH'
But where to put this SET lc_time_names = 'de-CH' ?

Regards
mpol_ch

mobhar · Post by **mobhar** » Fri Nov 25, 2022 4:45 pm

You may then post the related tables schema (CREATE TABLE ...) including the database view schema (CREATE VIEW ...) for more discussion.

arbei · Post by **arbei** » Fri Nov 25, 2022 5:31 pm

arbei wrote:

You may use Database_Connected server event (see the topic Server Events and Client Scripts in help file) to execute SET lc_time_names.

mpol_ch · Post by **mpol_ch** » Fri Nov 25, 2022 8:25 pm

Thank you for the information.
I am using an "view" in phpmaker.
How should I insert the following code it in to a view?
Is that possible?

$conn->execute("SET lc_time_names = 'ch-DE;");

Thanks
mpol_ch

arbei · Post by **arbei** » Sat Nov 26, 2022 10:32 am

As said you should use Datebase_Connected server event,
You should use correct locale value, read MySQL Server Locale Support.