PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: How to let the server know the client character set
Date: Apr 7 1998 2:18PM

>>>>> "Yasushi" == Yasushi Iwakata  writes:

    Yasushi> Hi.  I got the following a warning message when I ran
    Yasushi> "make test" after compiling sybperl-2.09_04 on Japanese
    Yasushi> Solaris 2.5.1.

    Yasushi> *****************Warning Message*************

    Yasushi> t/bcp...............Sybase message 2401, Severity 11,
    Yasushi> state 2 Line 1 Character set conversion is not available
    Yasushi> between client character set 'iso_1' and server character
    Yasushi> set 'sjis'.

    Yasushi> ok All tests successful.

    Yasushi> *****************Warning Message**************

    Yasushi> Sybase is using SJIS (Shift-JIS) as its character set.
    Yasushi> In my case, the client is "JPerl" , Perl5.004 with
    Yasushi> Japanese patch applied.  Since the client JPerl is also
    Yasushi> using Shif-JIS as its character set, it is not necessary
    Yasushi> to do any conversions.

    Yasushi> I would like to know how to let the server know the
    Yasushi> client is also using the same character set.  If it is
    Yasushi> not possible, I would like to supress this warning
    Yasushi> message at least.

You can:

Use DBSETLCHARSET() in your perl scripts to set the character set
of the client.
Customize the message handler to ignore message #2401.
Install the iso_1 character set on the server (in addition to the
shift-jis character set).

Michael