Hi all,
I'm using DBD::Sybase to connect locally to databases on a RH 9 box.
dsn looks like
dbi:Sybase:database=xxxxx;server=SYBASE;charset=is o_1
and another looks like
dbi:Sybase:database=yyyyy;server=SYBASE
If the ";charset=iso_1" is not present on the first dsn then I get an
error like this:
DBD::Sybase::db selectrow_array failed: Server message number=2409
severity=11 state=2 line=1 server=SS text=Cannot find the requested
character set in Syscharsets: name = 'cp437'
for any request. But the second dsn doesn't suffer from this problem.
Does anyone have any clue what the reason could be? The only thing I know
for sure about the dbs is that xxxxx was created in DBArtisan, and yyyyy
was created in sqsh.
Confused of Wolverhampton

Fri, 16 Dec 2005 20:06:05 +0000, Richard Gration wrote:

Hi all,

I'm using DBD::Sybase to connect locally to databases on a RH 9 box.
dsn looks like

dbi:Sybase:database=xxxxx;server=SYBASE;charset=is o_1

and another looks like

dbi:Sybase:database=yyyyy;server=SYBASE

If the ";charset=iso_1" is not present on the first dsn then I get an
error like this:

DBD::Sybase::db selectrow_array failed: Server message number=2409
severity=11 state=2 line=1 server=SS text=Cannot find the requested
character set in Syscharsets: name = 'cp437'

for any request. But the second dsn doesn't suffer from this problem.

Well - the second DSN tries to use the client charset based on the locale
of your session in RH9 (based on the value of the LANG env. variable). If
you unset the LANG variable you should get a working connection each
time.

course you should also be able to add the cp437 charset to the
dataserver, which is another way of solving the problem.

Michael