Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
French characters larger than English?
has no ratings.
Published: 18 Dec 2014
Revised: 22 Dec 2014 - 3271 days ago
Last viewed on: 05 Dec 2023 (4065 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

French characters larger than English? Published by: Chris Proctor on 18 Dec 2014 view comments(3)

Hi all. We have some stored procedures that retrieve a name parameter CHAR(35) and we are currently testing it with French characters. If the name is completely filled (all 35 chars) we're getting an "invalid string or buffer length" SQLSTATE HY090. Does this mean that French characters are somehow larger, or does it not recognize the characters, therefore being an invalid string?

Any suggestions would be greatly appreciated. Thanks!

Return to midrangenews.com home page.
Sort Ascend | Descend


(Sign in to Post a Comment)
Posted by: starbuck5250
Premium member *
Comment on: French characters larger than English?
Posted: 8 years 11 months 18 days 7 minutes ago

There is nothing special about French characters.  Hélène occupies 6 bytes, just as Helene does.  Well, in CCSID 819, they do.  What CCSID is your name defined to use?  What CCSID is the calling job using?  And finally, what does the code that's using this name look like?

Posted by: chrisp
Premium member *
Portland, OR
Comment on: French characters larger than English?
Posted: 8 years 11 months 17 days 23 hours 2 minutes ago

CREATE PROCEDURE OrderConfirmation

(in p_storeno dec(5,0), -- store number

in p_orderno dec(8,0), -- SODA order number

in p_cimcust char(18), -- CIM customer number

in p_dworder char(25), -- demandware order no

in p_saporder char(25), -- SAP order number

in p_sku dec(9,0), -- SKU

in p_upc char(48), -- UPC

in p_sapmatno char(18), -- SAP material number

in p_matdesc char(70), -- SAP material de!--script--ion

in p_sizdim char(8), -- size/dimension

in p_quantity dec(9,2), -- quantity

in p_rjctqty dec(9,2), -- reject quantity

in p_cancod char(10), -- cancel reason code

in p_linstat char(1), -- line status


in p_pono char(10), -- allocation po number

in p_bulkord char(10), -- bulk order number

in p_dccode char(15), -- DC code

in p_soldto char(17), -- SAP sold to

in p_soldnm char(35) -- SAP sold to name



insert into mlsoci (mocpo#, mocbo#, mocdc, mocsku, mocstr,

mocqty, mocupc, mocmat, mocsor, mocsld, mocnam) values(p_pono,

p_bulkord, p_dccode, p_sku, p_storeno, p_quantity, p_upc, p_sapmatno,

p_saporder, p_soldto, p_soldnm);




Posted by: starbuck5250
Premium member *
Comment on: French characters larger than English?
Posted: 8 years 11 months 14 days 20 hours 34 minutes ago

So I was thinking maybe a CCSID mis-match.  If all of these are the same, then that's probably not the issue:

What CCSID is the machine?  DSPSYSVAL QCCSID

What CCSID is the job trying the INSERT?  DSPJOB, option 2



Google tells me that HY090 is a Microsoft SQLSTATE.  Are you using the correct DB2 driver?  The DB2 LUW driver is not the same as the DB2 for i driver that comes with IBM i Access.