Re: What exactly is a "Binary Character" field? -- MIDRANGE-L

Subject: Re: What exactly is a "Binary Character" field?
From: "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
Date: Tue, 16 Jun 2015 16:52:21 -0700
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On 6/16/15 4:35 PM, CRPence wrote:

INSERT INTO test_file (BAR) VALUES( CAST('08 Bytes' as BINARY) )

Actually, if I do that, whether from STRSQL or from Squirrel, I get

Error: [SQL0332] Character conversion between CCSID 37 and CCSID 65535 not valid.

and if I change the job CCSID to 65535, then I don't get '08 Bytes' in the field; I get 'F0 00 00 00 00 00 00 00'

Just keeps getting weirder.

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: What exactly is a "Binary Character" field? , CRPence

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.