unknown 'locale' on Linux

[michel.weber]

Hi

A script i have been working on has been running on our Windows platform OK, but gives the following error on Linux (Debian)

<!-- 015 [search_COE]:36: Unknown locale `fr' -->

<!-- 000 [search_COE]:36: SQLPrepare() failed with -1 -->

the statment at line 36 is the following :
<sql "set locale='fr'"></sql>

Version Info :
Version: Commercial Version 5.01.1252999158 20090915 (i686-unknown-linux2.6.9-64-32)
Scripts Version: 5.1.88 Details: dowalk: 5.1.88/2.768 dowalk: 5.1.88/2.747 dowalk: /1.59 dowalk: /1.31 dowalk: /1.3 search: 5.1.88/2.733 search: /1.31 search: /1.3 Patch level: Scripts 5.1.88-Unix-javascript-
acls-addlFlds-charMatchMode-dbWalker-enhancedMeta-intCats-LAM-maintenance-metaSearch-replication-resAuth-resultsPerSite-cssNav-webService-xmlOutput-w/plugin

and

Version: Commercial Version 5.01.1258488718 20091117 (i686-intel-winnt-64-32)
Scripts Version: 5.1.88 Details: dowalk: 5.1.88/2.768 dowalk: 5.1.88/2.747 dowalk: /1.59 dowalk: /1.31 dowalk: /1.3 search: 5.1.88/2.733 search: /1.31 search: /1.3 Patch level: Scripts 5.1.88-Windows-javascript-
acls-addlFlds-charMatchMode-dbWalker-enhancedMeta-intCats-LAM-maintenance-metaSearch-replication-resAuth-resultsPerSite-cssNav-webService-xmlOutput-w/plugin

[John]

You can use locale -a to get a list of the locales installed on the Linux server. From one of our servers it looks like you might need to either use the locale fr_FR as there are separate locales for several of the French speaking countries, or create an alias for 'fr' to point to the one you want.