Tagged articles
6 articles
Page 1 of 1
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 19, 2020 · Databases

Understanding Oracle Character Sets, NLS_LANG Settings, and Import/Export Character Conversion

This article explains the fundamentals of Oracle character sets, how database and national character sets are defined, the role of NLS_LANG, the location and purpose of character set files, and practical guidance for import/export operations and character set conversion across different environments.

Character SetImport ExportNLS_LANG
0 likes · 22 min read
Understanding Oracle Character Sets, NLS_LANG Settings, and Import/Export Character Conversion
ITPUB
ITPUB
Jun 10, 2017 · Databases

Understanding Oracle Character Sets and NLS_LANG: A Complete Guide

Oracle character sets define how byte data maps to symbols, with NLS_LANG controlling client language, territory, and charset; this guide explains the components, naming conventions, differences between database and client sets, export/import conversion processes, and methods to view or modify character sets safely.

Export ImportNLS_LANGOracle
0 likes · 17 min read
Understanding Oracle Character Sets and NLS_LANG: A Complete Guide
ITPUB
ITPUB
Nov 15, 2016 · Databases

Mastering Oracle Character Sets and NLS_LANG: A Complete Guide

This article explains Oracle character sets, the NLS_LANG parameter format, the differences between database, national, and client character sets, how to query and modify them, and the impact on EXP/IMP data migration, providing practical commands and step‑by‑step procedures.

NLS_LANGOraclecharset conversion
0 likes · 16 min read
Mastering Oracle Character Sets and NLS_LANG: A Complete Guide
ITPUB
ITPUB
Aug 3, 2016 · Databases

How to View and Change Oracle Server and Client Character Sets Safely

This guide explains how to check the character set of an Oracle database and its client, demonstrates queries for server, instance, and session parameters, describes the risks of altering the server charset with ALTER DATABASE CHARACTER SET, provides safe conversion steps, and shows how to adjust client settings on Linux and Windows to avoid garbled Chinese text.

Character SetLinuxNLS_LANG
0 likes · 11 min read
How to View and Change Oracle Server and Client Character Sets Safely
ITPUB
ITPUB
Jun 28, 2016 · Databases

Fix Chinese Characters in Oracle Sqlplus on Linux Without Reboot

This guide explains why Chinese characters appear as question marks in Sqlplus on Linux, how to identify the server character set, and provides step‑by‑step instructions to set the NLS_LANG environment variable and apply it instantly using the source command.

Character SetDatabase ConfigurationLinux
0 likes · 4 min read
Fix Chinese Characters in Oracle Sqlplus on Linux Without Reboot