Re: same utf8 string is different in console and in browser (Sybase)

[choroba]

This can happen when one of the strings is utf-8, while the other one is bytes.

Compare:

#! /usr/bin/perl
use warnings;
use strict;
use feature qw{ say };
use utf8;
 
my @strings = ('школы',
               "\xd1\x88\xd0\xba\xd0\xbe\xd0\xbb\xd1\x8b");
 
say for @strings;
 
binmode STDOUT, ':encoding(UTF-8)';
say for @strings;

The first two lines are the same:

школы
школы

but once the output knows it expects UTF-8 (the third and fourth line), the output is different:

школы
ΡΠΊΠΎΠ»Ρ

You probably didn't tell Sybase your strings are UTF-8.

[alexander_lunev]

But you were right! I've changed way to connect to MSSQL, and when i connect through freetds.conf with DBI:Sybase:server=server_name;database=database_name", strings output to browser as they should! I have tried with syb_enable_utf8 => 1, tried to put charset=utf8 in DSN, with no changes. Now i add server to freetds.conf and add client charset = UTF-8 and it works.

Though i still don't get it, why the very bytes of $str turns different only because of script called by CGI...

[shmem]

So, some hidden thing there. Different environment settings for command line and web server?

[alexander_lunev]

I think it's not the case, because if i add binmode STDOUT, ':encoding(UTF-8)', output in console is the same for Pg and Sybase:

Sybase Ρ�ΠΊΠΎΠ»Ρ�#Π�Π°Ρ�Ρ�Π° > 0xD1
+ 0x88 0xD0 0xBA 0xD0 0xBE 0xD0 0xBB 0xD1 0x8B 0x23 0xD0 0x9A 0xD0 0xB
+0 0xD1 0x81 0xD1 0x81 0xD0 0xB0
Pg Ρ�ΠΊΠΎΠ»Ρ�#Π�Π°Ρ�Ρ�Π° > 0xD1 0x8
+8 0xD0 0xBA 0xD0 0xBE 0xD0 0xBB 0xD1 0x8B 0x23 0xD0 0x9A 0xD0 0xB0 0x
+D1 0x81 0xD1 0x81 0xD0 0xB0

But in browser again all different:

Sybase ?????#????? > 0x3F 0x3F 0x3F 0x3F 0x3F 0x23 0x3F 0x3F 0x3F 0x3F
+ 0x3F 
Pg ΡˆΠΊΠΎΠ»Ρ‹#ΠšΠ°ΡΡΠ° > 0xD1 0x88 0xD0 0xBA 0xD0 0xB
+E 0xD0 0xBB 0xD1 0x8B 0x23 0xD0 0x9A 0xD0 0xB0 0xD1 0x81 0xD1 0x81 0x
+D0 0xB0