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: iwakata at netscape dot com (Yasushi Iwakata)
Subject: Re: How to let the server know the client character set
Date: Apr 8 1998 5:06AM

Dear Mr.Peppler,

All three ways worked.  I am going to use DBSETLCHARSET().
Thank you very much for the useful suggestions.

Regards,
yasushi

Michael Peppler wrote:

> >>>>> "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



-
Netscape Communications Japan Ltd.
Tokyo Opera City Tower
3-20-2, Nishishinjyuku, Shinjuku-ku
Tokyo(191) Japan
Office Telephone: 03-5354-1752
Office Fax: 03-5354-1770