Get Oracle Database working with Umlauts and Special Characters
lazarus / 16-Databases

----------------------------------------------------------------------
gonz0 · 2015-11-28 09:19

When working with the Oracle Database you probably noticed that the
default components have trouble displaying some characters.

This is cause Lazarus displays all characters as UTF8.

So if you want to your application and database to work hand in hand
you have to do the following:

Change the Oracle CharacterSet to UTF8

Connect as SYSDBA.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SHUTDOWN
IMMEDIATE; STARTUP MOUNT; ALTER SYSTEM ENABLE RESTRICTED
SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER DATABASE
OPEN; ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8; SHUTDOWN
IMMEDIATE; STARTUP; 
Detailed explanation: http://community.microfocus.com/borland/test/sil
k_test/w/knowledge_base/17853.the-character-set-of-the-database-is-
not-utf8-error-when-creating-new-silktest-workbench-oracle-
database.aspx

Setup Environment Variable

http://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreI
nstall18.html



You don't have to do any casting of strings to get your oracle
database and the default Lazarus components work together.