Linux set locale
Author: t | 2025-04-25
Locale Management in Linux: This guide offers a comprehensive look into setting and modifying locales on Linux systems. Read more at Linux Locale Management . Advanced Locale
Change or Set Locales on Linux
This article is going to show you 3 ways to fix SSH locale environment variable error. What is locale environment variable? In Linux, a locale consists of four categories of environment variables:LANGUAGELC_ALLLC_*: LC_TYPE, LC_NUMERIC, LC_TIME…LANGThese environment variables define the system language, monetary format, date and time format etc on your Linux distribution. You can check out your locale environment variables by running the locale command in terminal:localeSample output:LANG=zh_CN.UTF-8LANGUAGE=zh_CNLC_CTYPE="zh_CN.UTF-8"LC_NUMERIC=en_US.UTF-8LC_TIME=en_US.UTF-8LC_COLLATE="zh_CN.UTF-8"LC_MONETARY=en_US.UTF-8LC_MESSAGES="zh_CN.UTF-8"LC_PAPER=en_US.UTF-8LC_NAME=en_US.UTF-8LC_ADDRESS=en_US.UTF-8LC_TELEPHONE=en_US.UTF-8LC_MEASUREMENT=en_US.UTF-8LC_IDENTIFICATION=en_US.UTF-8LC_ALL=You can see that the above output contains all four categories of locale environment variables.On Ubuntu, you can set LANGUAGE, LANG and LC_* variables graphically in system settings > language support.Systemd-based Linux distributions (Debian 8+, Ubuntu 15.04+, Fedora, CentOS7+, Arch Linux) can use the following command to set each locale environment variable.sudo localectl set-locale variable_name=valueFor example, set LANG=en_US.UTF-8.sudo localectl set-locale LANG=en_US.UTF-8Locale changes may need re-login or reboot to take effect.SSH Locale Environment Variable ErrorWhen you ssh into a remote Linux server, you might see the following locale related error.Failed to set locale, defaulting to Corperl: warning: Setting locale failed.perl: warning: Please check that your locale settings: LANGUAGE = (unset), LC_ALL = (unset), LC_TIME = "zh_CN.UTF-8", LC_MONETARY = "zh_CN.UTF-8", LC_ADDRESS = "zh_CN.UTF-8", LC_TELEPHONE = "zh_CN.UTF-8", LC_NAME = "zh_CN.UTF-8", LC_MEASUREMENT = "zh_CN.UTF-8", LC_IDENTIFICATION = "zh_CN.UTF-8", LC_NUMERIC = "zh_CN.UTF-8", LC_PAPER = "zh_CN.UTF-8", LANG = "en_US.UTF-8" are supported and installed on your system.perl: warning: Falling back to the standard locale ("C").locale: Cannot set LC_CTYPE to default locale: No such file or directorylocale: Cannot set LC_MESSAGES to default locale: No such file or directorylocale: Cannot set LC_ALL to
linux - How is the locale of a C program set to the C locale?
Default locale: No such file or directoryWhy does this locale error happen? Well, that’s because your SSH client forwards your locale environment variables from your local computer to the remote Linux server which doesn’t have the needed locale generated.This happens a lot if you are not a native English speaker. Normally you would configure a non-English language on your local computer, but most Linux servers by default only have the C locale (aka POSIX locale) and English locales generated.Now let me show you 3 ways to fix this error.Method 1: Generate Locales on the ServerTo fix this error, you can generate the needed locales on the Linux server. First open the /etc/locale.gen file on your server.sudo nano /etc/locale.genFind the needed locale and remove the # sign to uncomment. For example, to generate zh_CN.UTF-8 locale, find this line:#zh_CN.UTF-8 UTF-8Remove and # sign. Save and close the file. Then run the following command to generate it.sudo locale-genlocale-gen reads /etc/locale.gen file to know what locales to generate. You can also generate multiple locales by uncommenting multiple lines in that file.Method 2: Refuse Client Locale Environment VariableYou can tell your SSH server to refuse client locale environment variable. Open the SSH server configuration file on your Linux server.sudo nano /etc/ssh/sshd_configFind the following line.AcceptEnv LANG LC_*Change it toAcceptEnv noSave and close the file. Then restart SSH daemon.sudo systemctl restart sshOn RHEL, CentOS, Fedora, you need to runsudo systemctl restart sshdOn Fedora/CentOS server, then are multiple locale-related SSH settings.AcceptEnv LANG LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGESAcceptEnvlocale: Cannot set LC_ALL to default locale: No - Arch Linux
8 compatibility mode. After you install the agent, configure the scheduling manager to work with the agent. For more information, see the documentation for your scheduling manager.Text entry fields support only characters that belong to the default character set for the locale on the Windows machine. The installation fails if you enter characters that are not part of the default character set for the chosen locale. For example, you cannot enter Japanese characters in either the installation directory name or the service name on a machine that uses an English locale. Also, note that by default some UNIX systems use UTF8 encoding, which allows non-native characters to be used and accepted for installation. However, although the characters are recognized and accepted during installation, they will prevent the agent from running. Collect Information About the Scheduling ManagerThis topic does not apply to AutoSys Workload Automation installations.During the agent installation, you are prompted for information about your scheduling manager. Speak to your administrator and collect the following information:Scheduling Manager Name The Scheduling Manager Name corresponds to the Scheduling Manager ID that is required during installation.IP address The IP address corresponds to the Scheduling Manager Address that is required during installation.Port number The Port number corresponds to the Scheduling Manager Port that is required during installation. Agent Installation OptionsThe interactive agent installation program prompts you for the following information:Java Virtual MachineFor Linux, AIX, HPUX and Windows Please Choose a 64-bit Java VM for Use by the Installed Application Use the Java VM installed with this applicationChoose a Java VM already installed on this system Default: Use the Java VM installed with this applicationFor HPE Integrity NonStop Please choose a Java 32-bit VM for use by the System Agent JVMs listed below consist of JRE versions 1.8 32-bit found in the PATH environment variable.. Locale Management in Linux: This guide offers a comprehensive look into setting and modifying locales on Linux systems. Read more at Linux Locale Management . Advanced LocaleLinux: Define Locale and Language Settings - ShellHacks
What is UTF-8?UTF-8 (Unicode Transformation Format) is an 8-bit Unicode conversion format. It is used to encode Unicode characters in groups of 8-bit variable byte numbers. Character encoding is a way of telling a computer how to interpret raw zeros and ones into real characters. When we write text to a file, the words and sentences we create are made up of different characters, and the characters are arranged in a character set. Or the codes written in a programming language are converted into this format by the system and presented to the user.For example, in the Mousepad application, UTF-8 is defined as the default encoding:If you are working on Linux operating system, you should use these converters. If you have received a warning/error regarding UTF-8, read this post. In this article, we will explain the steps to enable UTF-8 on Linux operating systems.Let's enable UTF-8 for systems based on major distributions that are used by most users on Linux.How to enable UTF-8 Redhat Based OSThe following steps can be applied in linux distributions based on Redhat operating system such as Centos, Rocky Linux, AlmaLinux, Fedora, etc.Step-1: Show current UTF-8 settingsFirst view the settings current in the system:[foc@rocky9 ~]$ localeLANG=en_GB.UTF-8LC_CTYPE="en_GB.UTF-8"LC_NUMERIC="en_GB.UTF-8"LC_TIME="en_GB.UTF-8"...or[foc@rocky9 ~]$ localectl System Locale: LANG=en_GB.UTF-8 VC Keymap: us X11 Layout: usThe language you used and the UTF format are also displayed.Step-2: Show the list of available localesUse the following command to list available languages and UTF formats:[foc@rocky9 ~]$ localectl list-locales...en_SC.UTF-8en_SG.UTF-8en_US.UTF-8...After this command, you will see a long list.Step-3: Change UTF-8 settingTo change the UTF settings, you can do it by giving the set-locale and LANG parameters to the localectl command. For example:[foc@rocky9 ~]$ sudo localectl set-locale LANG=en_US.UTF-8or you can manually edit the /etc/locale.conf file:[foc@rocky9 ~]$ sudo vi /etc/locale.confChange en_GB.UTF-8 to en_US.UTF-8. Then check system locale settings:[foc@rocky9 ~]$ cat /etc/locale.conf LANG=en_GB.UTF-8How to enable UTF-8 Debian Based OSIn this step, let's explain how to make UFT settings in distributions such as Debian based systems, Pardus, Ubuntu, Mint.Step-1: Show current UTF-8 settingsYou can view the UTF settings with the locale command:foc@ubuntu22:~$ localeLANG=en_US.UTF-8LANGUAGE=LC_CTYPE="en_US.UTF-8"...Step-2: Show the list of available localesReconfigure the locales package to show the list of available locales:foc@ubuntu22:~$ sudo dpkg-reconfigure localesStep-3: Change UTF-8 settingRun the locales package with root user or sudo:Select UTF and language from the list. Determine which of the selected settings will be default:Press OK:foc@ubuntu22:~$ sudo dpkg-reconfigure localesGenerating locales (this might take a while)... en_GB.UTF-8... done en_US.UTF-8... done tr_TR.UTF-8... doneGeneration complete.The settings have been applied successfully.Referencesunix.stackexchange.com - How can I enable UTF-8 support in the Linux console? Can't find what you're searching for? Let us assist you. Enter your query below, and we'll provide instant results tailored to your needs.How to Change or Set System Locales in Linux
ME SDK 8.2:MEEP media related packages and JSR177 APDU package are not supported on Linux platformRelease 8.2 does not support javax.microedition.media, javax.microedition.media.control, and javax.microedition.apdu packages on Linux platform.Installation of 32-bit support libraries on 64-bit Linux machines is required to run Java ME SDKE.g., to install 32-bit support libraries on Ubuntu 14.0.4, perform the following commands:sudo dpkg --add-architecture i386sudo apt-get updatesudo apt-get install libc6:i386 libncurses5:i386 libstdc++6:i386Reboot the machine.On Windows platform, Java ME SDK does not install if the path to the destination folder or the user profile folder contains non-ASCII charactersThe installer is not able to load certain files that are located on a path with non-ASCII characters if the language for non-Unicode programs is set to a locale other than the one used for that path. For example, if the destination folder where you want to install Java ME SDK or the user profile folder contains Russian characters, the language for non-Unicode programs must be set to Russian locale. This will not happen if you use only ASCII characters in your paths.However, if you need to have non-ASCII characters, you can manage the language for non-Unicode programs in Windows as follows:Open the Control Panel, select Clock, Language, and Region, and then select Region and Language.Open the Administrative tab and check the Language for non-Unicode programs section.Click Change system locale and select the locale that is used in your paths.Click OK and then Apply.Only Eclipse rendered by GTK2 is currently supportedFor more information about running Eclipse IDE on top of GTK2, see the Oracle Java Micro Edition Software Development Kit Developer's Guide.Installation and Runtime Security GuidelinesOracle Java ME SDK 8.2 requires an execution model that makes certain networked resources available for emulator execution. These required resources might include, but are not limited to, a variety of communication capabilities between the Oracle Java ME SDK 8.2 components. It is important to note that the Oracle Java ME SDK 8.2 installation and runtime system is fundamentally a developer system that is not specifically designed to guard against any malicious attacks from outside intruders. Given this, the Oracle Java ME SDK 8.2 architecture canSet system locale on Linux - UNBLOG Tutorials
Automatic selection of ybdumprolesupdate-alternatives: using /opt/ybtools/bin/ybdumproles to provide /usr/bin/ybdumproles (ybdumproles) in auto modeupdate-alternatives: setting up automatic selection of ybdumpschemaupdate-alternatives: using /opt/ybtools/bin/ybdumpschema to provide /usr/bin/ybdumpschema (ybdumpschema) in auto modeupdate-alternatives: setting up automatic selection of ybloadupdate-alternatives: using /opt/ybtools/bin/ybload to provide /usr/bin/ybload (ybload) in auto modeupdate-alternatives: setting up automatic selection of ybrelayupdate-alternatives: using /opt/ybtools/bin/ybrelay to provide /usr/bin/ybrelay (ybrelay) in auto modeupdate-alternatives: setting up automatic selection of ybrestoreupdate-alternatives: using /opt/ybtools/bin/ybrestore to provide /usr/bin/ybrestore (ybrestore) in auto modeupdate-alternatives: setting up automatic selection of ybsqlupdate-alternatives: using /opt/ybtools/bin/ybsql to provide /usr/bin/ybsql (ybsql) in auto modeupdate-alternatives: setting up automatic selection of ybtokenupdate-alternatives: using /opt/ybtools/bin/ybtoken to provide /usr/bin/ybtoken (ybtoken) in auto modeupdate-alternatives: setting up automatic selection of ybunloadupdate-alternatives: using /opt/ybtools/bin/ybunload to provide /usr/bin/ybunload (ybunload) in auto modeupdate-alternatives: setting up automatic selection of ybrelay-initupdate-alternatives: using /opt/ybtools/config/ybrelay-init to provide /usr/bin/ybrelay-init (ybrelay-init) in auto modeOn Linux clients, the tools are installed by default in /opt/ybtools. For example:$ cd /opt/ybtoolsme@yb:/opt/ybtools$ lsbin config integrations lib license.txtNote: On RHEL and AIX clients, you can install ybtools in a different preferred location. You do not have to use the default installation directory.If the locale on the client system is not compatible with the locale set for the database, you may see an error of the following form when you connect to a database with the ybsql client:$ ybsql -d yellowbrick -h vm100.yb.io -U yellowbrickPassword for user yellowbrick: ybsql: FATAL: conversion between LATIN1 and LATIN9 is not supportedMake sure your client locale is consistent with the database locale. You can use the locale command to return client settings:$ localeLANG="en_US.UTF-8"LC_COLLATE="en_US.UTF-8"LC_CTYPE="en_US.UTF-8"LC_MESSAGES="en_US.UTF-8"...To check which locales are installed on your client system, use the locale -a command.. Locale Management in Linux: This guide offers a comprehensive look into setting and modifying locales on Linux systems. Read more at Linux Locale Management . Advanced Locale $ locale -k LC_ADDRESS. To change or set system locale in Linux. We can change or set system locale in Linux by using the update-locale program. Using the LANG variable, it will allow us to set up the locale for the entireComments
This article is going to show you 3 ways to fix SSH locale environment variable error. What is locale environment variable? In Linux, a locale consists of four categories of environment variables:LANGUAGELC_ALLLC_*: LC_TYPE, LC_NUMERIC, LC_TIME…LANGThese environment variables define the system language, monetary format, date and time format etc on your Linux distribution. You can check out your locale environment variables by running the locale command in terminal:localeSample output:LANG=zh_CN.UTF-8LANGUAGE=zh_CNLC_CTYPE="zh_CN.UTF-8"LC_NUMERIC=en_US.UTF-8LC_TIME=en_US.UTF-8LC_COLLATE="zh_CN.UTF-8"LC_MONETARY=en_US.UTF-8LC_MESSAGES="zh_CN.UTF-8"LC_PAPER=en_US.UTF-8LC_NAME=en_US.UTF-8LC_ADDRESS=en_US.UTF-8LC_TELEPHONE=en_US.UTF-8LC_MEASUREMENT=en_US.UTF-8LC_IDENTIFICATION=en_US.UTF-8LC_ALL=You can see that the above output contains all four categories of locale environment variables.On Ubuntu, you can set LANGUAGE, LANG and LC_* variables graphically in system settings > language support.Systemd-based Linux distributions (Debian 8+, Ubuntu 15.04+, Fedora, CentOS7+, Arch Linux) can use the following command to set each locale environment variable.sudo localectl set-locale variable_name=valueFor example, set LANG=en_US.UTF-8.sudo localectl set-locale LANG=en_US.UTF-8Locale changes may need re-login or reboot to take effect.SSH Locale Environment Variable ErrorWhen you ssh into a remote Linux server, you might see the following locale related error.Failed to set locale, defaulting to Corperl: warning: Setting locale failed.perl: warning: Please check that your locale settings: LANGUAGE = (unset), LC_ALL = (unset), LC_TIME = "zh_CN.UTF-8", LC_MONETARY = "zh_CN.UTF-8", LC_ADDRESS = "zh_CN.UTF-8", LC_TELEPHONE = "zh_CN.UTF-8", LC_NAME = "zh_CN.UTF-8", LC_MEASUREMENT = "zh_CN.UTF-8", LC_IDENTIFICATION = "zh_CN.UTF-8", LC_NUMERIC = "zh_CN.UTF-8", LC_PAPER = "zh_CN.UTF-8", LANG = "en_US.UTF-8" are supported and installed on your system.perl: warning: Falling back to the standard locale ("C").locale: Cannot set LC_CTYPE to default locale: No such file or directorylocale: Cannot set LC_MESSAGES to default locale: No such file or directorylocale: Cannot set LC_ALL to
2025-03-30Default locale: No such file or directoryWhy does this locale error happen? Well, that’s because your SSH client forwards your locale environment variables from your local computer to the remote Linux server which doesn’t have the needed locale generated.This happens a lot if you are not a native English speaker. Normally you would configure a non-English language on your local computer, but most Linux servers by default only have the C locale (aka POSIX locale) and English locales generated.Now let me show you 3 ways to fix this error.Method 1: Generate Locales on the ServerTo fix this error, you can generate the needed locales on the Linux server. First open the /etc/locale.gen file on your server.sudo nano /etc/locale.genFind the needed locale and remove the # sign to uncomment. For example, to generate zh_CN.UTF-8 locale, find this line:#zh_CN.UTF-8 UTF-8Remove and # sign. Save and close the file. Then run the following command to generate it.sudo locale-genlocale-gen reads /etc/locale.gen file to know what locales to generate. You can also generate multiple locales by uncommenting multiple lines in that file.Method 2: Refuse Client Locale Environment VariableYou can tell your SSH server to refuse client locale environment variable. Open the SSH server configuration file on your Linux server.sudo nano /etc/ssh/sshd_configFind the following line.AcceptEnv LANG LC_*Change it toAcceptEnv noSave and close the file. Then restart SSH daemon.sudo systemctl restart sshOn RHEL, CentOS, Fedora, you need to runsudo systemctl restart sshdOn Fedora/CentOS server, then are multiple locale-related SSH settings.AcceptEnv LANG LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGESAcceptEnv
2025-04-16What is UTF-8?UTF-8 (Unicode Transformation Format) is an 8-bit Unicode conversion format. It is used to encode Unicode characters in groups of 8-bit variable byte numbers. Character encoding is a way of telling a computer how to interpret raw zeros and ones into real characters. When we write text to a file, the words and sentences we create are made up of different characters, and the characters are arranged in a character set. Or the codes written in a programming language are converted into this format by the system and presented to the user.For example, in the Mousepad application, UTF-8 is defined as the default encoding:If you are working on Linux operating system, you should use these converters. If you have received a warning/error regarding UTF-8, read this post. In this article, we will explain the steps to enable UTF-8 on Linux operating systems.Let's enable UTF-8 for systems based on major distributions that are used by most users on Linux.How to enable UTF-8 Redhat Based OSThe following steps can be applied in linux distributions based on Redhat operating system such as Centos, Rocky Linux, AlmaLinux, Fedora, etc.Step-1: Show current UTF-8 settingsFirst view the settings current in the system:[foc@rocky9 ~]$ localeLANG=en_GB.UTF-8LC_CTYPE="en_GB.UTF-8"LC_NUMERIC="en_GB.UTF-8"LC_TIME="en_GB.UTF-8"...or[foc@rocky9 ~]$ localectl System Locale: LANG=en_GB.UTF-8 VC Keymap: us X11 Layout: usThe language you used and the UTF format are also displayed.Step-2: Show the list of available localesUse the following command to list available languages and UTF formats:[foc@rocky9 ~]$ localectl list-locales...en_SC.UTF-8en_SG.UTF-8en_US.UTF-8...After this command, you will see a long list.Step-3: Change UTF-8 settingTo change the UTF settings, you can do it by giving the set-locale and LANG parameters to the localectl command. For example:[foc@rocky9 ~]$ sudo localectl set-locale LANG=en_US.UTF-8or you can manually edit the /etc/locale.conf file:[foc@rocky9 ~]$ sudo vi /etc/locale.confChange en_GB.UTF-8 to en_US.UTF-8. Then check system locale settings:[foc@rocky9 ~]$ cat /etc/locale.conf LANG=en_GB.UTF-8How to enable UTF-8 Debian Based OSIn this step, let's explain how to make UFT settings in distributions such as Debian based systems, Pardus, Ubuntu, Mint.Step-1: Show current UTF-8 settingsYou can view the UTF settings with the locale command:foc@ubuntu22:~$ localeLANG=en_US.UTF-8LANGUAGE=LC_CTYPE="en_US.UTF-8"...Step-2: Show the list of available localesReconfigure the locales package to show the list of available locales:foc@ubuntu22:~$ sudo dpkg-reconfigure localesStep-3: Change UTF-8 settingRun the locales package with root user or sudo:Select UTF and language from the list. Determine which of the selected settings will be default:Press OK:foc@ubuntu22:~$ sudo dpkg-reconfigure localesGenerating locales (this might take a while)... en_GB.UTF-8... done en_US.UTF-8... done tr_TR.UTF-8... doneGeneration complete.The settings have been applied successfully.Referencesunix.stackexchange.com - How can I enable UTF-8 support in the Linux console? Can't find what you're searching for? Let us assist you. Enter your query below, and we'll provide instant results tailored to your needs.
2025-04-09ME SDK 8.2:MEEP media related packages and JSR177 APDU package are not supported on Linux platformRelease 8.2 does not support javax.microedition.media, javax.microedition.media.control, and javax.microedition.apdu packages on Linux platform.Installation of 32-bit support libraries on 64-bit Linux machines is required to run Java ME SDKE.g., to install 32-bit support libraries on Ubuntu 14.0.4, perform the following commands:sudo dpkg --add-architecture i386sudo apt-get updatesudo apt-get install libc6:i386 libncurses5:i386 libstdc++6:i386Reboot the machine.On Windows platform, Java ME SDK does not install if the path to the destination folder or the user profile folder contains non-ASCII charactersThe installer is not able to load certain files that are located on a path with non-ASCII characters if the language for non-Unicode programs is set to a locale other than the one used for that path. For example, if the destination folder where you want to install Java ME SDK or the user profile folder contains Russian characters, the language for non-Unicode programs must be set to Russian locale. This will not happen if you use only ASCII characters in your paths.However, if you need to have non-ASCII characters, you can manage the language for non-Unicode programs in Windows as follows:Open the Control Panel, select Clock, Language, and Region, and then select Region and Language.Open the Administrative tab and check the Language for non-Unicode programs section.Click Change system locale and select the locale that is used in your paths.Click OK and then Apply.Only Eclipse rendered by GTK2 is currently supportedFor more information about running Eclipse IDE on top of GTK2, see the Oracle Java Micro Edition Software Development Kit Developer's Guide.Installation and Runtime Security GuidelinesOracle Java ME SDK 8.2 requires an execution model that makes certain networked resources available for emulator execution. These required resources might include, but are not limited to, a variety of communication capabilities between the Oracle Java ME SDK 8.2 components. It is important to note that the Oracle Java ME SDK 8.2 installation and runtime system is fundamentally a developer system that is not specifically designed to guard against any malicious attacks from outside intruders. Given this, the Oracle Java ME SDK 8.2 architecture can
2025-04-17Click to view our Accessibility PolicySkip to contentDatabaseTechnologiesOracle Instant Client ODBC Installation NotesOracle's Instant Client ODBC software is a standalone package that offers the full functionality of the Oracle ODBC driver (except the Oracle service for Microsoft Transaction Server) with a simple install.The ODBC driver has Oracle's standard client-server version interoperability, see Support Doc ID 207303.1. For example Instant Client ODBC 19c can connect to Oracle Database 11.2 or later.Installing Oracle Instant Client Basic and Basic LiteInstant Client ODBC requires the Oracle Instant Client Basic or Basic Light package (depending on your locale requirements) also be installed. Download the desired package from OTN for your operating system and follow the installation instructions on the download page. For example, unzip the package to C:\instantclient_19_3 on Windows, unzip to /opt/oracle/instantclient_19_3 on Linux or other platforms, or use yum to install the RPM packages on Linux.More details on Oracle Instant Client is in the Oracle Call Interface Programmer's Guide.Installing Oracle Instant Client ODBCOn Linux and UNIX 1. Download Install the Instant Client Basic or Basic Light package as described above.2. Download the Instant Client ODBC package. Unzip it in the same directory as your Basic or Basic Light package. Or, if using the RPM package on Linux, install it with yum.3. Install the unixODBC driver manager if it is not already available. Refer to the "Recommended unixODBC Driver Manager version" section in this document for more information.4. Execute odbc_update_ini.sh from the Instant Client directory.5. Set any Oracle Globalization variables required for your locale. See the Oracle Database Globalization Support Guide for more information. For example on Linux you could set export NLS_LANG=JAPANESE_JAPAN.JA16EUC to work in the JA16EUC character in Japanese.Usage: odbc_update_ini.sh [ ] ParameterDescriptionODBCDM_HomeunixODBC driver manager home directory pathInstall_Location*Oracle Instant Client directory path. The default path is the current directoryDriver_Name*Driver name to identify
2025-04-21ODBC Drivers for Linux/FreeBSD This article describes the ODBC drivers provided by Exasol to connect applications running on Linux or FreeBSD with an Exasol system. The Exasol ODBC drivers for Linux and FreeBSD are tested on the following systems: Linux CentOS 7 CentOS 8 Stream OpenSUSE 15 Debian 10 Ubuntu 20.04 LTS Ubuntu 22.04 LTS FreeBSD FreeBSD 13.2 FreeBSD 14.0 The Exasol ODBC driver needs at least OpenSSL 1.1 to run. On some operating systems, OpenSSL must be installed separately. Download and install the ODBC driver Download the latest driver for your operating system from the Exasol Download Portal. Run the following commands to extract the package in a directory:For Linux/FreeBSD: tar -xzf Exasol_ODBC-.tar.gzFor Solaris: gtar -xzf Exasol_ODBC-.tar.gz For configuration information, see the readme.txt file included in the driver package. License Each driver package includes the latest version of the license for the driver. The license allows you to bundle the driver with third-party software, for example when creating plugins for a BI tool. For more details, refer to the license file which is located in the folder where the driver was installed. Configure ODBC driver and data sources To configure the driver, run the config_odbc program to generate the odbc.ini file. Change into the install directory and then run config_odbc as shown below: cd Exasol_ODBC-* ./config_odbc Running the config_odbc performs the following operations: Scan the system for available ODBC driver manager Check for missing (3rd party) packages Create an odbc.ini config file Create a wrapper script to start applications Test the database connectivity Suggest the correct DSN an application needs based on the driver manager it uses The generated odbc.ini file contains DSN entries for all supported ODBC driver managers. To further configure the options in the odbc.ini file, see Connection strings. The config_odbc program also allows non-interactive use. For details, run the following command: Known Issues Issue Reason Solution config_odbc does not start The operating system may not have the full Perl installation. Install a full Perl system and try again. Fix: minimal Debian apt-get install perl Fix: minimal CentOS 7 yum install perl-Digest-MD5 Error "Data source name not found, and no default driver specified" Wrong version of the unixODBC is used because of multiple installation instances. Specify the correct version of the unixODBC through isql -version. The unixODBC driver manager is using the wrong odbc.ini file. Specify the correct odbc.ini file through the environment variable ODBCINI. Error "Invalid UTF-8 character in input" Wrong locale defined in the LC_ALL variable. Define a locale in the LC_ALL variable that can display the characters properly. Missing or wrong characters in output of console or your ODBC application Incompatible locale defined in the odbc.ini file. Set the environment variables LC_CTYPE and LC_NUMERIC or the parameters CONNECTIONLCCTYPE and CONNECTIONLCNUMERIC in the odbc.ini file to a locale that can display the characters. Applications using the DataDirect driver manager need UTF-8 locales.
2025-04-14