sha1_file

rtrim

[edit] Last updated: Fri, 24 May 2013

setlocale

(PHP 4, PHP 5)

setlocale — Modifie les informations de localisation

Description

string setlocale ( int $category , string $locale [, string $... ] )

string setlocale ( int $category , array $locale )

Modifie les informations de localisation.

Liste de paramètres

category

category est une constante (ou une chaîne) qui spécifie la catégorie de fonctions affectées par la configuration de localisation :

LC_ALL pour toutes les constantes suivantes
LC_COLLATE pour la comparaison de chaînes de caractères. Voir strcoll()
LC_CTYPE pour la classification et la conversion de caractères. Voir strtoupper()
LC_MONETARY pour localeconv()
LC_NUMERIC pour le séparateur décimal. Voir localeconv()
LC_TIME pour le format de date et d'heure avec strftime()
LC_MESSAGES pour les réponses système (disponible si PHP a été compilé avec libintl)

locale

Si locale est NULL ou la chaîne vide (""), les noms de locales seront pris dans l'environnement, à partir des variables de même nom que les catégories ci-dessus, ou depuis "LANG".

Si locale vaut "0", la configuration locale ne sera pas modifiée, et la configuration courante sera retournée.

Si locale est un tableau ou bien est suivi par des paramètres additionnels, alors chaque élément du tableau ou chaque paramètre tente d'être défini comme nouvelle locale jusqu'à ce qu'un réussisse. Cela est pratique si la locale est connue sous différents noms sur des systèmes différents ou bien pour prévoir une autre valeur en cas de non disponibilité de la locale choisie.

...

(Chaîne ou tableau de paramètres optionnel à essayer comme configuration de la locale jusqu'à réussite.)

Note:
Sous Windows, setlocale(LC_ALL, '') définit les noms de la locale depuis la configuration de la langue/de la région du système d'exploitation (accessible depuis le Panneau de Contrôle).

Valeurs de retour

Retourne la nouvelle configuration locale, ou FALSE si la localisation n'est pas implémentée sur votre plate-forme, si la variable de localisation n'existe pas, ou si la catégorie spécifiée n'est pas valide.

Un nom de catégorie invalide générera un message d'alerte. La liste des noms de locales/catégories peut être trouvée en consultant la » RFC 1766 ainsi que l'» ISO 639. Les différentes plates-formes possèdent des conventions de nommages différentes.

Note:
La valeur retournée par setlocale() dépend du système sur lequel PHP est installé. setlocale() retourne exactement ce que la fonction système setlocale retourne.

Historique

Version	Description
5.3.0	Cette fonction émet désormais une alerte `E_DEPRECATED` si une chaîne est passée comme paramètre `category` au lieu d'une des constantes LC_*.
4.3.0	Passer plusieurs locales devient possible.
4.2.0	Passer `category` en tant que chaîne est déconseillé, utilisez les constantes mentionnées plus haut à la place. Les passer en tant que chaînes (entre guillemets) provoquera l'affichage d'un message d'avertissement.

Exemples

Exemple #1 Exemple avec setlocale()


<?php
/* Configure le script en hollandais */
setlocale(LC_ALL, 'nl_NL');

/* Affiche : vrijdag 22 december 1978 */
echo strftime("%A %e %B %Y", mktime(0, 0, 0, 12, 22, 1978));

/* Essai de différentes valeurs possible pour l'allemand depuis PHP 4.3.0 */
$loc_de = setlocale(LC_ALL, 'de_DE@euro', 'de_DE', 'de', 'ge');
echo "L'identifiant de l'allemand sur ce système est '$loc_de'";
?>

Exemple #2 Exemple avec setlocale() sous Windows


<?php
/* Configure le script en hollandais */
setlocale(LC_ALL, 'nld_nld');

/* Affiche : vrijdag 22 december 1978 */
echo strftime("%A %d %B %Y", mktime(0, 0, 0, 12, 22, 1978));

/* Essai de différentes valeurs possible pour l'allemand depuis PHP 4.3.0 */
$loc_de = setlocale(LC_ALL, 'de_DE@euro', 'de_DE', 'deu_deu');
echo "L'identifiant de l'allemand sur ce système est '$loc_de'";
?>

Notes

Avertissement

L'information locale est maintenue par processus, non par thread. Si vous faites fonctionner PHP sur un serveur multi-threadé comme IIS ou Apache sur Windows, vous pourriez obtenir des changements soudains des configurations locales pendant qu'un script fonctionne, même si celui-ci n'appelle jamais la fonction setlocale(). Ceci survient à cause des autres scripts qui fonctionnent dans des threads différents du même processus. Ces scripts changent les configurations locales dans le processus au complet en utilisant la fonction setlocale().

Astuce

Les utilisateurs de Windows trouverons des informations utiles à propos du paramètre locale sur le site web MSDN de Microsoft. Les valeurs de locales supportées peuvent être trouvées » sur la page de la documentation des chaînes du langage et les chaînes de pays/région » sur la page de la documentation des chaînes de pays/région.

sha1_file

rtrim

[edit] Last updated: Fri, 24 May 2013

add a note User Contributed Notes setlocale - [50 notes]

down

russ at eatmymonkeydust dot com ¶

1 year ago


If you are looking for a getlocale() function simply pass 0 (zero) as the second parameter to setlocale().



Beware though if you use the category LC_ALL and some of the locales differ as a string containing all the locales is returned:



<?php

echo setlocale(LC_ALL, 0);



// LC_CTYPE=en_US.UTF-8;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_MESSAGES=C;LC_PAPER=C;LC_NAME=C;

// LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;LC_IDENTIFICATION=C



echo setlocale(LC_CTYPE, 0);



// en_US.UTF-8



setlocale(LC_ALL, "en_US.UTF-8");

echo setlocale(LC_ALL, 0);



// en_US.UTF-8



?>



If you are looking to store and reset the locales you could do something like this:



<?php



$originalLocales = explode(";", setlocale(LC_ALL, 0));

setlocale(LC_ALL, "nb_NO.utf8");



// Do something



foreach ($originalLocales as $localeSetting) {

  if (strpos($localeSetting, "=") !== false) {

    list ($category, $locale) = explode("=", $localeSetting);

  }

  else {

    $category = LC_ALL;

    $locale   = $localeSetting;

  }

  setlocale($category, $locale); 

}



?>



The above works here (Ubuntu Linux) but as the setlocale() function is just wrapping the equivalent system calls, your mileage may vary on the result.

down

brice/axice/be ¶

4 years ago


Pay attention to the syntax.


- UTF8 without dash ('-')


- locale.codeset and not locale-codeset.





Stupid newbie error but worth knowing them when starting with gettext.





<?php


$codeset = "UTF8";  // warning ! not UTF-8 with dash '-'


        


// for windows compatibility (e.g. xampp) : theses 3 lines are useless for linux systems 





putenv('LANG='.$lang.'.'.$codeset);


putenv('LANGUAGE='.$lang.'.'.$codeset);


bind_textdomain_codeset('mydomain', $codeset);





// set locale


bindtextdomain('mydomain', ABSPATH.'/locale/');


setlocale(LC_ALL, $lang.'.'.$codeset);


textdomain('mydomain');


?>





where directory structure of locale is (for example) :


locale/fr_FR/LC_MESSAGES/mydomain.mo


locale/en_US/LC_MESSAGES/mydomain.mo





and ABSPATH is the absolute path to the locale dir





further note, under linux systems, it seems to be necessary to create the locale at os level using 'locale-gen'.

down

dv at josheli dot com ¶

8 years ago


On Novell Netware, the language codes require hyphens, not underscores, and using anything other than LC_ALL doesn't work directly.



So... (from their support list)....



You have to set TIME, NUMERIC etc. info in two steps as given below rather than one. This is due to the limitation of setlocale function of LibC.

<?php

   setlocale(LC_ALL, 'es-ES');

   $loc = setlocale(LC_TIME, NULL);

   echo strftime("%A %e %B %Y", mktime(0, 0, 0, 12, 22, 1978));

  // jeuves 22 diciembre 1978

?>

This should work.



or of course, reset LC_ALL...

<?php

setlocale(LC_ALL, 'es-ES');

echo strftime("%A %e %B %Y", mktime(0, 0, 0, 12, 22, 1978));

setlocale(LC_ALL, '');

// jeuves 22 diciembre 1978

?>

down

r dot nospam dot velseboer at quicknet dot nospam dot nl ¶

10 years ago


be careful with the LC_ALL setting, as it may introduce some unwanted conversions. For example, I used 



setlocale (LC_ALL, "Dutch");



to get my weekdays in dutch on the page. From that moment on (as I found out many hours later) my floating point values from MYSQL where interpreted as integers because the Dutch locale wants a comma (,) instead of a point (.) before the decimals. I tried printf, number_format, floatval.... all to no avail. 1.50 was always printed as 1.00 :(



When I set my locale to :



 setlocale (LC_TIME, "Dutch");



my weekdays are good now and my floating point values too. 



I hope I can save some people the trouble of figuring this out by themselves.



Rob

down

noog at libero dot it ¶

12 years ago


On windows:


Control Panel->International Settings


You can set your locale and customize it


And locale-related PHP functions work perfectly

down

data dot ocean dot italia at gmail dot com ¶

4 months ago


Instead, using php with IIS, I had to use this line for Italian language...



<?php setlocale(LC_ALL, 'Italian_Italy.1250'); ?>

down

ostapk ¶

5 years ago


There is a new PECL extension under development called intl (it will be available in PHP5.3). Meanwhile all who rely on the setlocale() and friends should be aware about the limitations of them as covered in this post on the onPHP5.com blog: http://www.onphp5.com/article/22

down

Anonymous ¶

7 years ago


The example from bruno dot cenou at revues dot org below shows the possibility, but I want to spell it out: you can add charset info to setlocale.



Example:



Into my utf-8-encoded page I want to insert the name of the current month, which happens to be March, in German "März" - with umlaut. If you use



   setlocale(LC_TIME, 'de_DE');

   echo strftime("%B");



this will return "M&auml;rz", but that html-entity will look like this on a utf-8 page: "M?rz". Not what I want.



But if you use



   setlocale(LC_TIME, 'de_DE.UTF8');  // note the charset info !

   echo strftime("%B");



this returns "M√§rz", which, on utf-8, looks like it should: "März".

down

mk at totu dot com ¶

9 years ago


Be carefull - setting a locale which uses commas instead of dots in numbers may cause a mysql db not to understand the query:


<?php


setlocale(LC_ALL,"pl");


$price = 1234 / 100; // now the price looks like 12,34


$query = mysql_query("SELECT Id FROM table WHERE price='".$price."'");


?>


Even if there is a price 12.34 - nothing will be found

down

misc dot anders at feder dot dk ¶

11 years ago


Under FreeBSD, locale definitions are stored in the /usr/share/locale/ directory. Danish time formats and weekdays, for instance, are stored in /usr/share/locale/da_DK.ISO_8859-1/LC_TIME.

down

Lucas Thompson <lucas at slf dot cx> ¶

13 years ago


The Open Group has an excellent document available on the setlocale() library function, most of which applies to the PHP function of the same name.





http://www.opengroup.org/onlinepubs/7908799/xbd/locale.html





WARNING: This document might be a little too complex for people who came from HTML to PHP.





If you migrated from the world of C programming you'll be a locale master after reading this document.

down

Kari Sderholm aka Haprog ¶

4 years ago


It took me a while to figure out how to get a Finnish locale correctly set on Ubuntu Server with Apache2 and PHP5.



At first the output for "locale -a" was this:

C

en_US.utf8

POSIX



I had to install a finnish language pack with

"sudo apt-get install language-pack-fi-base"



Now the output for "locale -a" is:

C

en_US.utf8

fi_FI.utf8

POSIX



The last thing you need to do after installing the correct language pack is restart Apache with "sudo apache2ctl restart". The locale "fi_FI.utf8" can then be used in PHP5 after restarting Apache.



For setting Finnish timezone and locale in PHP use:

<?php

date_default_timezone_set('Europe/Helsinki');

setlocale(LC_ALL, array('fi_FI.UTF-8','fi_FI@euro','fi_FI','finnish'));

?>

down

c dot madmax at gmail dot com ¶

3 months ago


<?php



// the last foldername only contains a german umlaut (lower a with two dots = \xE4 in ISO-8859-1)

$path = "/home/madmax/photos_from_the_last_10_years/\xE4"



// php escapeshellarg remove characters (depends on locale settings)

// the following example will delete /home/madmax/photos_from_the_last_10_years/

// instead of /home/madmax/photos_from_the_last_10_years/ä



shell_exec(sprintf('rm -fr %s' escapeshellarg($path)));



// dear php developers, how stupid is that?

// I tell you: it is very very stupid! The problem exists since years and nothing happens (see bug #54391)



// this code will not remove all your photos of the last 10 years :)

function binary_safe_escapeshellarg_that_is_not_totally_buggy_and_do_not_remove_f___ing_characters($string)

{

    return(@sprintf("'%s'", @strtr($string, Array("\x27" => "\x27\x5C\x27\x27"))));

};



// delete /home/madmax/photos_from_the_last_10_years/ä

// and not /home/madmax/photos_from_the_last_10_years/

shell_exec(sprintf('rm -fr %s' binary_safe_escapeshellarg_that_is_not_totally_buggy_and_do_not_remove_f___ing_characters($path))); // binary safe!



?>

down

tomas dot hampl at gmail dot com ¶

2 years ago


On Linux, setlocale() depends on the installed locales. To see which locales are available to PHP, run this from the terminal:



"locale -a"



Provided list are all locales that are available on your server for PHP to use. To add a new one, run



locale-gen <locale name> (this may need sudo / root permissions), for example to add a Czech locale, run something like this:



"sudo locale-gen cs_CZ.utf8"



Then you can use this locale declaration:



setlocale(LC_ALL, 'cs_CZ.utf8');

down

leif at neland dot dk ¶

2 years ago


Regarding dash'es in locale, it appears they should be omitted entirely.



In /etc/locale.gen I have



da_DK.ISO-8859-15 ISO-8859-15



but locale -a gives 



da_DK.iso885915



which is the format setlocale()  wants.



(Debian)

down

garygendron at yahoo dot com ¶

2 years ago


For a php Mysql query, you could also use, for french canadian, in this example :



$query = 'SET lc_time_names = "fr_CA"';

$result = mysql_query($query) or die("Query failed");



$query = 'SELECT @@lc_time_names';

$result = mysql_query($query) or die("Query failed");



$query = 'SELECT id, created, YEAR(created) as year, MONTH(created) as month,' .

' CONCAT_WS(" ", MONTHNAME(created), YEAR(created)) as archive' .            

' FROM #__TABLE as e' .

' GROUP BY archive' .

' ORDER BY id DESC'; 



Your data will be displayed in any locale setting you want. You may even $_GET[lc_time_name] from your multilanguage website.

down

wisborg ¶

4 years ago


It is correct as stated below that it is common that the UTF-8 should be used without the dash. However on some systems (e.g. MacOS 10.4) the dash is essential.

down

birkholz at web dot de ¶

7 years ago


When i tried to get the current locale (e.g. after i set the lang to german with setlocale(LC_ALL, 'de_DE'); ), the following did not work on my suse linux 9.0-box:

$currentLocale = setlocale(LC_ALL, NULL);

This code did a reset to the server-setting.



$currentLocale = setlocale(LC_ALL, 0); works perfectly for me, but the manual says NULL and 0 are equal in this case, but NULL seems to act like "".

down

flavioacvalverde at gmail dot com ¶

1 year ago


For Portugal I had to use





<?php setlocale(LC_ALL, 'Portuguese_Portugal.1252'); ?>





using php with IIS on Windows server.

down

mvanbaak ¶

6 years ago


To complement Sven K's tip about debian:



You can also install the package locales-all

That one holds all the locales there are in compiled form.

down

Edwin Martin ¶

7 years ago


Debian users: Addition to Gabor Deri's note: if setlocale doesn't work in your locale and you're on Debian, and Gabor Deri's note doesn't work, you have to install the locales package.



As root, type: "apt-get install locales" and it will be installed.

down

Omer Sabic ¶

3 years ago


On Linux/Apache, when you install and try to use a new locale, the setlocale() function with the new locale will fail sometimes, but not always. To furthermore complicate, setlocale() will always complete with any of the previously installed locales. This would seem a really weird behaviour, which you can fix by restarting Apache, as Kari Sderholm aka Haprog mentioned, but I felt it needed to be properly pointed out.

down

benny at bennyborn dot de ¶

4 years ago


I had the problem (Debian), that the language de_DE was installed, but setlocale always returned false. I installed the language AFTER compiling PHP - that was the point. If you add some languages afterwards, you have to recompile php ;)

down

Arjon ¶

4 years ago


Please take heed and read the warning above if you are running on a XAMPP or any other Windows apache server! It just took me far too long to figure this out; and all the while there was a warning right on the page.



If you're experiencing shifting locale settings (check with setlocale(LC_ALL,0), returning the current locale stuff) and you're running a windows server, then it's not just you! Again, I urge everyone to read the red, but oh so easy not to read, warning message on this page.

down

michal dot kocarek at brainbox dot cz ¶

4 years ago


Note about using UTF-8 locale charset on Windows systems:





According to MSDN, Windows setlocale()'s implementation does not support UTF-8 encoding.





Citation from "MSDN setlocale, _wsetlocale" page (http://msdn.microsoft.com/en-us/library/x99tb11d.aspx):


The set of available languages, country/region codes, and code pages includes all those supported by the Win32 NLS API except code pages that require more than two bytes per character, such as UTF-7 and UTF-8. If you provide a code page like UTF-7 or UTF-8, setlocale will fail, returning NULL.





So basically, code like


<?php setlocale(LC_ALL, 'Czech_Czech Republic.65001'); // 65001 is UTF-8 codepage ?>


does not work on Windows at all.





(written in time of PHP 5.2.4)

down

de ronino at kde (reverse it) ¶

4 years ago


I experienced the behavior stated in the above Warning box: Running PHP5 on a multithreaded Apache made the current locale change sometimes all of a sudden within a script, so strftime() output wasn't in the required format.



I recompiled Apache with the prefork MPM and now it works like a charm. Took me a long time to find out the reason as I overlooked the warning box searching for either a bug report or a programming error of mine...

down

Periklis ¶

5 years ago


In *some* Windows systems, setting LC_TIME only will not work, you must either set LC_ALL or both LC_CTYPE and LC_TIME. BUT if you have already set LC_TIME using setlocale earlier in the script, dates will not be affected! For example:

<?php

setlocale(LC_TIME, 'greek');

setlocale(LC_CTYPE, 'greek');

?>

will not work, while 

<?php

setlocale(LC_CTYPE, 'greek');

setlocale(LC_TIME, 'greek');

?>

will do the job.

down

szepeshazi at gmail dot com ¶

6 years ago


For those of you who are unfortunate enough (like me) to work in Windows environment, and try to set the locale to a language _and_ to UTF-8 charset, and were unable to do it, here is a workaround.



For example to output the date in hungarian with UTF-8 charset, this will work:



    $dateString = "%B %d., %A";

    setlocale(LC_ALL,'hungarian');

    $res=strftime($dateString);

    echo(iconv('ISO-8859-1', 'UTF-8', $res));



If anybody knows how to set the locale on Windows to the equivalent of "hu_HU.UTF-8" on unix, please do tell me.

down

bruno dot cenou at revues dot org ¶

7 years ago


A little function to test available locales on a sytem :



<?php

function list_system_locales(){

    ob_start();

    system('locale -a'); 

    $str = ob_get_contents();

    ob_end_clean();

    return split("\\n", trim($str));

}



$locale = "fr_FR.UTF8";

$locales = list_system_locales();



if(in_array($locale, $locales)){

        echo "yes yes yes....";

}else{

        echo "no no no.......";

}



?>

down

-1

Leigh Morresi ¶

4 years ago


Setting locale that is not supported by your system will result in some string operations returning a question mark "?" in your strings where it needs to perform transliteration.



1) Always check the return of setlocale() to ensure it has set to something supported



2) on Linux you can use the "locale -a" command to find a list of supported locales

down

-1

bryn AT lunarvis DOT com ¶

5 years ago


Posting this in the hope it might be useful to others, as I could find very little info anywhere. If you want to use a Welsh locale and have the suitable language support installed, you pass 'cym' (abbreviated form of Cymraeg) to setlocale:



<?php

setlocale(LC_TIME, 'cym');

$welsh= gmstrftime("%A, %B %Y - %H:%M",time());

echo $welsh;

?>



The above certainly applies to Windows systems, but should also apply to Unix if the required support is installed.



Cheers,



Bryn.

down

-1

jorg-spamm at omnimedia dot no ¶

10 years ago


I needed to compile and install some extra locales to get this to work on RH7.3. Probably just me not doing a proper installation, but this is what it took to fix it:



localedef -ci no_NO -f ISO_8859-1 no_NO

down

-1

Morgan Christiansson <mog at linux dot nu> ¶

13 years ago


check /usr/share/locale/ if you want more info about the locale available with your *NIX box





there is also a file called /usr/share/locale/locale.alias with a list of aliases


such as swedish for sv_SE





so on all boxes i have accounts on (rh 6.0 and slack 3.4) you can just use setlocale("LC_ALL","swedish"); or other prefered language in plain english.





However, the weekdays were in all lowercase :(





Note: export LC_ALL=swedish made a lot of programs swedish for me, it's also possible to make them russian or japanese :)

down

phcorp ¶

1 year ago


To find the locale of a Unix system:

<?php system('locale -a') ?>

down

buana95 at yahoo dot com ¶

4 years ago


This will works for Indonesian on all platform (Windows, Linux and others Nix server):



<?php

echo '<pre>' . "\n";



//Add english as default (if all Indonesian not available)



setlocale(LC_ALL, 'id_ID.UTF8', 'id_ID.UTF-8', 'id_ID.8859-1', 'id_ID', 'IND.UTF8', 'IND.UTF-8', 'IND.8859-1', 'IND', 'Indonesian.UTF8', 'Indonesian.UTF-8', 'Indonesian.8859-1', 'Indonesian', 'Indonesia', 'id', 'ID', 'en_US.UTF8', 'en_US.UTF-8', 'en_US.8859-1', 'en_US', 'American', 'ENG', 'English');



//will output something like: Minggu, 17 Agustus 2008

echo strftime("%A, %d %B %Y") . "\n";



echo '</pre>' . "\n";

?>

down

jonas at jonashaag dot de ¶

4 years ago


On Ubuntu, you have to take p.e. "de_DE.utf8", all available languages you can get with:

    locale -a

down

Clayton Smith ¶

6 years ago


If you already have all the locales installed and "locale -a" is only showing a few languages, then edit /etc/locale.gen and add a line, e.g., es_MX ISO-8859-1.  After you add the line, run the command locale-gen for it to generate the locales based on those settings.

down

pigmeu at pigmeu dot net ¶

8 years ago


!!WARNING!!



The "locale" always depend on the server configuration.



i.e.:

When trying to use "pt_BR" on some servers you will ALWAYS get false. Even with other languages.



The locale string need to be supported by the server. Sometimes there are diferents charsets for a language, like "pt_BR.utf-8" and "pt_BR.iso-8859-1", but there is no support for a _standard_ "pt_BR".



This problem occours in Windows platform too. Here you need to call "portuguese" or "spanish" or "german" or...



Maybe the only way to try to get success calling the function setlocale() is:

setlocale(LC_ALL, "pt_BR", "pt_BR.iso-8859-1", "pt_BR.utf-8", "portuguese", ...);



But NEVER trust on that when making functions like date conversions or number formating. The best way to make sure you are doing the right thing, is using the default "en_US" or "en_UK", by not calling the setlocale() function. Or, make sure that your server support the lang you want to use, with some tests.



Remember that: Using the default locale setings is the best way to "talk" with other applications, like dbs or rpc servers, too.



[]s



Pigmeu

down

elindset at hoved dot net ¶

11 years ago


In FreeBSD I had to use no_NO.ISO8859-1 instead of just no_NO..



<?PHP

    setlocale (LC_ALL, 'no_NO.ISO8859-1');

    echo strftime ("%A %e %B %Y", time());

?>

down

-1

ts at websafe dot pl ¶

1 year ago


If Your linux box returns false on setlocale (so setlocale is not working as expected):



var_dump(setlocale(LC_TIME, 'fr_FR.UTF8', 'fr.UTF8', 'fr_FR.UTF-8', 'fr.UTF-8'));



make sure the glibc package is installed :-)

down

-1

bardouty at gmail dot com ¶

4 years ago

down

-1

Un_passant ¶

4 years ago


For debian/ubuntu, don't forget the charset UFT8. 



// Works on Ubuntu 8.04 Server

setlocale(LC_TIME, 'fr_FR.UTF8', 'fr.UTF8', 'fr_FR.UTF-8', 'fr.UTF-8');

down

-1

alvaro at demogracia dot com ¶

4 years ago


A generalization for mk (26-Jan-2004) and totu (09-Sep-2002). The issue is not restricted to MySQL. For instance, when PHP needs to cast a floating point variable to string, it obeys the LC_NUMERIC settings:



<?php



$foo = 29.95;



echo "Locale: " . setlocale(LC_NUMERIC, 0) . "\n";

echo "Foo: $foo\n";



setlocale(LC_NUMERIC, 'Spanish_Spain.28605');

echo "Locale: " . setlocale(LC_NUMERIC, 0) . "\n";

echo "Foo: $foo\n";



?>



Under Windows, this code prints:



Locale: C

Foo: 29.95

Locale: Spanish_Spain.28605

Foo: 29,95

down

-1

Georg ¶

5 years ago


To set locale to 'de_DE' on my Debian 4 machine I had to:

- uncomment 'de_DE' in file /etc/locale.gen and afterwards

- run locale-gen from the shell

down

-1

lifeless ¶

6 years ago


if your server is an ubuntu (debian like)

you need to install the locales you want (default is english and your language) go to aptitude and install -language-pack-*-base it will resolve dependencies and will try to install a suggested package, remove it if you don't care and proceed.

down

-1

Sven K ¶

6 years ago


If your system doesn't show any installed locales by "locale -a", try installing them by "dpkg-reconfigure locales" (on debian).

down

-1

glenn at europlan dot no ¶

7 years ago


In most Unix/Linux system, you could use:



locale -a



This will list all available locales on the server.

down

-2

Charlo Dante ¶

4 years ago


Edwin Martin wrote already a note for Debian users, but it didn't work for me.



What DID work was this: 



apt-get install locales-all



which installs more than the same apt-get without the '-all'



With 'locales-all' I got all languages running well.

down

-3

Ludovico Grossi ¶

1 year ago


Please note that LC_NUMERIC (or LC_ALL) will convert the decimal separator every time you put it in a string, EVEN IF THE STRING IS A QUERY.

This is a problem for every locale that uses the comma as a decimal separator. Look at this example:



<?php

setlocale(LC_ALL, "it_IT"); // locale with comma for decimals

$decimal_number = 0.5;

$query = "SELECT * FROM Table WHERE decimal_field > ".(float)$decimal_number; // casting to float is useless, since the conversion to a string is done after

?>



Then, the query fill fail because it will be converted to:



SELECT * FROM Table WHERE decimal_field > 0,5 

(note the comma!)



I suggest to be sure that LC_NUMERIC is set to a standard locale, then use other formatting functions to display formatted numbers when needed.



<?php

setlocale(LC_ALL, 'it_IT');

setlocale(LC_NUMERIC, 'en_US'); // let's overwrite the decimal separator

?>

down

-3

bogdan at iHost dot ro ¶

9 years ago


On some systems (at least FreeBSD 4.x) the format for a `locale' is, for example, ro_RO.ISO8859-2. If you use ro_RO instead setlocale will return FALSE. Just browse in /usr/share/locale and see what is the name of the directory holding your `locale' and use that name in your scripts:



<?php

  clearstatcache();

  $pos = strrpos ($_SERVER["PHP_SELF"], "/");

  $fisier = substr ($_SERVER["PHP_SELF"], $pos + 1);

  $result = filemtime ($fisier);

  $local = setlocale (LC_TIME, 'ro_RO.ISO8859-2');

  if ($local == "ro_RO.ISO8859-2") {

    $modtime = strftime '%e&nbsp;%B&nbsp;%Y&nbsp;%H:%M', $result);

  } else {

    $modtime = strftime ('%d.%m.%Y&nbsp;%H:%M', $result);

  }

  printf ("Ultima&nbsp;actualizare: %s\\n", $modtime);

?>

add a note