Get Oracle Database working with Umlauts and Special Characters

[gonz0]

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][+][-]

1. SHUTDOWN IMMEDIATE;
2.  
3. STARTUP MOUNT;
4.  
5. ALTER SYSTEM ENABLE RESTRICTED SESSION;
6.  
7. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
8.  
9. ALTER DATABASE OPEN;
10.  
11. ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
12.  
13. SHUTDOWN IMMEDIATE;
14.  
15. STARTUP;
16.  

Detailed explanation: http://community.microfocus.com/borland/test/silk_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/AnyInstAdmPreInstall18.html



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