|
Rob, It a Mapics file and has a CCSID of 65535 Bob IT Guy -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx Sent: Thursday, March 01, 2007 1:40 PM To: Midrange Systems Technical Discussion Subject: Re: iSeries Access/ SQL for Windows Question That would have been my first suggestion. What CCSID do you have on the file? Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com "Bob Anderson" <banderson@xxxxxxxxxxxxxxxxxxx> Sent by: midrange-l-bounces@xxxxxxxxxxxx 03/01/2007 01:35 PM Please respond to Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> To "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx> cc Fax to Subject iSeries Access/ SQL for Windows Question Good Afternoon, I am trying to do some SQL queries in iSeries Navigator. The queries return the data fine but the character field come back as garbage. I have tried changing the JDBC translation but when I check the box for translation and click OK it does nothing and the queries never change. Thais on a V5R3 box with V5R3 iSeries Access with the latest PTFS Thanks Bob Anderson IT Guy Kent Sporting Goods 433 Park Ave. S New London OH 44851 419-929-7021 x315 email: banderson@xxxxxxxxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.