When I'm trying to retrieve data from AS400, I received the below error:
The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
How do I know which code page to use besides the default of 1252?
Software/Hardware used:
ASKED:
June 24, 2008 11:44 PM
UPDATED:
April 29, 2010 1:59 PM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
Without knowing what code page (CCSID) you’re converting from and what data you’re converting, no one can tell you anything useful. It’s like asking “What kind of box do I need to put my stuff in? A box 2′ wide, 2′ deep and 1′ tall doesn’t work right.”
Tom
Use the Display File Field Description (DSPFFD) command against the table/file. Review the display and record the various Coded Character Set Identifier (CCSID) values shown for the columns you are selecting. Get back to us with each of the unique CCSID values that you found.
With that information we could then recommend an appropriate Windows code page.