codepage problem on new install

dataservices job design
1

Hi,

Just did a new install and can’t figure out how to get this right.

DS version XI 12.2.0 on Windows 2008R2

I have a Sybase 12.5 database using codepage cp850. (open client version 15).

But strange characters ë, Ë, Ä are always converted to ? , doesn’t matter what settings I use in the datastore.

I’v followed this cases
My own case for the older version :

https://bobj-board.org/t/122518

and this one:

https://bobj-board.org/t/164259

But I get only a ? instead of the ë, Ë, Ä characters.

Someone a clue who to solve this?

Huub (BOB member since 2007-11-05)

2

What is the codepage setting in the datastore?

Werner Daehn :de: (BOB member since 2004-12-17)

3

I’v tried different approaches:

1: same settings as in original install of DI 11.7:
so Sybase open client us_english,utf8 and DataStore: iso-8859-1

2: DS: cp850 , Sybase open client default

3: DS: cp850 , Sybase open us_english,utf8

4: Everyting default.

Results are always the same, ? for the characters with diacritics.

Huub (BOB member since 2007-11-05)

4

I don’t know Sybase, okay?

So if you changed the setting to UTF-8, you should align the datastore to that as well and set the DS cdepage to utf-8 as well.
Or both to cp850. But always in sync.

We receive a stream of hex values from the database and need to translate each value into a character. If you tell the database to use 0x20AC for the € char and then you set DS datastore codepage to ASCII, we will receive the values 0x20 and 0xAC and translate those into the ASCII chars for these values.

Werner Daehn :de: (BOB member since 2004-12-17)

5

Installed the latest sp3 for DS and a dedicated Sybase 32 bits driver.
Now it’s working.

Huub (BOB member since 2007-11-05)