question on code page conversion in import utility

Harishkumar .Pathangay

question on code page conversion in import utility

Hi,

Secnario 1: File Type Modifier Code Page is specified in Import Utility as '1257' and Database Code Page is also '1252' and you are running the Import Utility from Linux Client with Code Page '1208'. Then Import Utility does perform Code Page Conversion between Modifier Code Page to Application Code Page to DB Code Page. The Import Ran successfully. But Truncation of Column Errors appear if column size is not 2 bytes, because 1252 [1 byte char] to 1208 [2 byte char] to 1252 [1 byte char].


Scenario 2 : File Type Modifier Code Page is specified in Import Utility as '1252' and Database Code Page is also '1252' and you are running the Import Utility from Linux Client with Code Page '1208'. Then Import Utility does not perform any Code Page Conversion between Modifier Code Page to Application Code Page to DB Code Page. The Import Ran successfully. But I was expecting Truncation of Column Errors, because 1252 to 1208 to 1252 should cause truncation as in Scenario 1.
Why the such a difference? If DB Code Page and Modifier Code Page are same, the Import Utility by passes intermediate Application Code Page Conversion. Which is not as per KC Document.

thanks in advance for any inputs, harish pathangay

 

Harishkumar .Pathangay

RE: question on code page conversion in import utility
(in response to Harishkumar .Pathangay)

hi,

any inputs?

thanks,

harish pathangay

Harishkumar .Pathangay

RE: question on code page conversion in import utility
(in response to Harishkumar .Pathangay)

hi,

any help?

thanks,

harish p