Meta Thinking, Meta Working
Let's take a look at the functions to find the number of UTF-8 bytes and characters in Sybase ASE DBMS. This function was created and used in a project that converts from Sybase ASE Non-Unicode encoding, EUC-KSC, to Unicode encoding, UTF-8. * UTF-8 encoding Reference: UTF-8 – Wikipedia, the encyclopedia of all of us (wikipedia.org) EUC-KSC converts columns declared as varchar(10) to UTF-8...
In this article, we briefly look at DBeaver, one of the tools that connects to the database, executes queries, and checks the results, and examines DBeaver dark theme, Excel download, and font settings. 1. Overview of DBeaver DBeaver is a general-purpose database query tool. These days, there are so many different databases...
I posted 10 articles on how to review and references to Oracle Character Set conversion, and the entire table of contents of the Oracle Character Set conversion explanation is compiled and posted separately. Click on the title of the table of contents to jump to the content of the article. 1. Need to convert Oracle Character Set 1.1. Misspecified Character Set (US7ASCII) 1.2....
Let's take a look at the CLOB type Korean conversion method. In the US7ASCII character set DB, you can check how to convert the CLOB type including Hangul to AL32UTF8 and the conversion result. This is a continuation of the previous article. Oracle Character Set Conversion(9): 6. User Implementation Character Set Conversion Method(2)...
Continuing from the previous article (Oracle Character Set Conversion (8): 6. How to Convert a User-implemented Character Set (1)), we look at how to convert a user-implemented Character Set. You can check how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 using DB Link, CTAS, and UTL_RAW packages. 6.2.3. Method 3) DB Link & CTAS & UTL_RAW...
Let's take a look at the user-implemented Character Set conversion method. You can check how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 by using Oracle Utitlity Data Pump Export, Import. Methods that require separate implementation require technical verification and various...
Examine KO16MSWIN949 environment CSSCAN execution result. You can check schema creation, directory creation, csscan execution result file scan.txt, scan.out, scan.err contents, and csscan purpose. 5.4. EN16MSWIN949 Environment CSSCAN Execution Result 5.4.1. Execute the script below on the schema created KO16MSWIN949 instance to csscan...
Examine the US7ASCII environment CSSCAN execution result. Schema creation, directory creation, csscan execution result file scan.txt, scan.out, scan.err content, execution result table backup contents can be checked. This is a continuation of the previous article. Oracle Character Set Conversion(5): 5. Oracle recommended method...
Let's take a look at Oracle's recommended character set conversion method. You can check how to use CSALTER and its limitations, how to use CSSCAN and its execution order, the execution result file, and the DDL that creates the CSSCAN execution result storage table. This is a continuation of the previous article. Oracle Character Set Conversion(4): 4.Test Environment...
Continuing from the previous article, we look at the configuration of the Oracle Character Set conversion test environment. You can check Oracle server environment configuration (three instances, DB Link creation), test table creation, and test data creation scripts. This test environment was later used in the character set conversion process...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español