Anyone can help me?
How can I load Turkish text files (with special characters) into a DB2 table? I have tried the load setting the DB2CODEPAGE variable to 1208 and my DB were created as CODESET 'UTF-8' TERRITORY 'TR'.
You have not given any explanation about the error messages you have or what the exact problem is (data is not being loaded, special characters doesn't seem to be correctly written into db..etc ). So I assume you have difficulty in writing and displaying Turkish characters in the text file.
I have tried the load oparation with your settings.
A database with CODESET 'UTF-8' and TERRITORY 'TR'
The command I have used to load data:
db2 load from C:\data.del of del modified by codepage=1254 replace into mytable
The format of the data in data.del file:
Structure of mytable:
CREATE TABLE MYTABLE(
It works well with this configuration.
You can add "modified by codepage=1254" to your load command if you haven't before and then try.
Code set is a name for an encoding scheme. Code page is a number for an encoding scheme. You can find the code set and code page relationship in DB2 Administration Guide - National Language Consideration.