Re: PHP odbc translation

["Franco Biaggi" <fbiaggi@xxxxxxxxxx>]

Beppe,
you can change it at system level: CHGSYSVAL QCCSID(....)

On Thu, 25 Sep 2003 18:01:00 +0200, Beppe Costagliola wrote:

>Hi Joe,

>I've put CCSID 280 and now I get right data.

>Btw, I'm wondering if this CCSID can be set somewhere to have a more clean
>solution.

>Thanks for the suggestion.
>Beppe.

>----- Original Message ----- 
>From: "Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>
>To: "Java Programming on and around the iSeries / AS400"
><java400-l@xxxxxxxxxxxx>
>Sent: Thursday, September 25, 2003 5:26 PM
>Subject: Re: PHP odbc translation


>>
>>     Hi Beppe,
>>
>>     I sort of missed where J-a-v-a fits into your question; it's really an
>> AS/400 DB2/SQL specific question.  But, since this kind of issue also
>comes
>> up in JDBC, here goes.
>>
>>     The culprit is one of my favorite gripes, CCSID 65535.  I've always
>> felt, and expressed to the NLS guy at COMMON, that the default behavior
>was
>> the wrong choice.
>>
>>     The basics are that whenever a dynamic column is created, the
>> database returns it as a CCSID 65535 field.  I'll be a little vague, but
>> "dynamic" here means that data outside of the table data is
>> joined/concatenated/whatever "inside" the DBMS and returned.  So, even
>> though you probably have "translate binary" set, this statement:
>>
>> "select  Code, trim(FirstName) concat ' ' concat LastName from Table"
>>
>> still returns CCSID 65535 data and looks like garbage.  The blank ( ' ' )
>> causes the problem.
>>
>>     When I ran across it a few years ago, I was in a rush and used this
>> solution:
>>
>> SELECT
>>     CAST(  yourDynamicColumnExpression
>>         AS CHAR CCSID 37 )
>>             AS whatYouDecideToCallTheDynamicColumn
>>
>>     I notice you are in Italy, so CCSID 37 may not be right for you; check
>> the CCSID for your standard jobs and use that.  The Unicode CCSID may also
>> work; I haven't tried that ( yep, bad for an i18n guy. )
>>
>>     Notice that this is completely non-portable.  If I were doing it
>today,
>> with time, I would look for a more portable solution or do it from the
>> client.
>>
>>     HTH,
>>
>>
>>                                                          Joe Sam
>>
>> Joe Sam Shirah -        http://www.conceptgo.com
>> conceptGO         -        Consulting/Development/Outsourcing
>> Java Filter Forum:       http://www.ibm.com/developerworks/java/
>> Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
>> Going International?    http://www.jguru.com/faq/I18N
>> Que Java400?             http://www.jguru.com/faq/Java400
>>
>>
>>
>> ----- Original Message -----
>> From: "Beppe Costagliola" <beppecosta@xxxxxxxx>
>> To: <JAVA400-L@xxxxxxxxxxxx>
>> Sent: Thursday, September 25, 2003 4:35 AM
>> Subject: PHP odbc translation
>>
>>
>> > I'm using a php script to get data via odbc (both db and Php - in Pase
>> > mode - are on the same Iseries).
>> >
>> > If I run this query :
>> > "select  Code, trim(FirstName) concat LastName from Table"
>> > I get the correct result for both fields returned, apart that FirstName
>> and
>> > LastName are joined together.
>> >
>> > But if I run this:
>> > "select  Code, trim(FirstName) concat ' ' concat LastName from Table"
>> > I get the correct result for Code but ebcdic untraslated data for the
>> second
>> > column.
>> >
>> > However if I code:
>> > "select  Code, trim(FirstName) concat substr(FirstName, 30, 1) concat
>> > LastName from Table" (assuming that position 30 of Firstame is a blank)
>I
>> > get FirstName and LastName separated by one blank char in readable form.
>> >
>> > Does anybody has got such a problem ?
>> >
>> > Thanks.
>> > Beppe.
>> >
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
>mailing list
>> To post a message email: JAVA400-L@xxxxxxxxxxxx
>> To subscribe, unsubscribe, or change list options,
>> visit: http://lists.midrange.com/mailman/listinfo/java400-l
>> or email: JAVA400-L-request@xxxxxxxxxxxx
>> Before posting, please take a moment to review the archives
>> at http://archive.midrange.com/java400-l.

>_______________________________________________
>This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
>To post a message email: JAVA400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>or email: JAVA400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/java400-l.



-----------------------------------------------------------------------------
*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne