Problems with code page
This is a discussion on Problems with code page within the DB2 forums, part of the Database Server Software category; --> I have created a (German) database with "Using Codeset ISO8859-1 territory DE". Now when I'm importing from an ixf ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 04:45 AM
| ||||
| ||||
 Problems with code page I have created a (German) database with "Using Codeset ISO8859-1 territory DE". Now when I'm importing from an ixf file, I get sometimes SQL3050W Conversions on the data will be made between the IXF file code page "923" and the application code page "819". and sometimes "... page 1208". Why I get different numbers for the application code page? I think the application is the import utility. Why does it not take the databases code page, which is 819? And what determines the code page of the import utility? Regards, -- Burkhard Schultheis Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim Email: schultheis@tde-online.de Phone: +49 7245 9287-21      |
|
02-27-2008, 04:45 AM
| |||
| |||
| Re: Problems with code page Burkhard Schultheis schrieb: > I have created a (German) database with "Using Codeset ISO8859-1 > territory DE". Now when I'm importing from an ixf file, I get sometimes > > SQL3050W Conversions on the data will be made between the IXF file code > page "923" and the application code page "819". > > and sometimes "... page 1208". > > Why I get different numbers for the application code page? I think the > application is the import utility. Why does it not take the databases > code page, which is 819? And what determines the code page of the import > utility? > I forgot: DB2 V8.2 FP7a on SuSE Linux 9.3, Intel. Regards, -- Burkhard Schultheis Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim Email: schultheis@tde-online.de Phone: +49 7245 9287-21 |
|
02-27-2008, 04:53 AM
| ||||
| ||||
| Re: Problems with code page Try the following: export DB2CODEPAGE=819 do the export on the other mashine do export DB2CODEPAGE=819 do the import export and import utilities use the codepage that is set on the client machine. Hope this helps. Best regards, Kovi Burkhard Schultheis wrote: > Burkhard Schultheis schrieb: >> I have created a (German) database with "Using Codeset ISO8859-1 >> territory DE". Now when I'm importing from an ixf file, I get sometimes >> >> SQL3050W Conversions on the data will be made between the IXF file code >> page "923" and the application code page "819". >> >> and sometimes "... page 1208". >> >> Why I get different numbers for the application code page? I think the >> application is the import utility. Why does it not take the databases >> code page, which is 819? And what determines the code page of the import >> utility? >> > > I forgot: DB2 V8.2 FP7a on SuSE Linux 9.3, Intel. > > Regards, |
Linear Mode
