Sybase is sustituting some specials characters for "\1xA"

Question

I have a problem between two enviroments in Sybase IQ

The procedure in pre-production enviroment the specials characters are correct inserted and they look like this (ä)

   case when  MyColum = "Something schäft" then X

In produccion nerverless when i look the procedure its writing.

      case when  MyColum = "Something  \x1A ft" then X

Could somebody tell me the root of the problem?

Thanks in advance, Enrique

score 0 · Answer 1 · answered Nov 29 '17 at 14:40

0

i think your problem is not in Sybase, its your editor.

with following query you can check which encoding is set on your sybase

SELECT DB_PROPERTY( 'CharSet' );

the result is for example ISO_8859

your texteditor should set the self encoding.. and not UTF8 or something other

answered Nov 29 '17 at 14:40

MarKuz

But it doesnt explain why in Pre production is correct and why in production no. Both are Sybase and both comen from the same editor. – Enrique Benito Casado Nov 29 '17 at 14:55
1

Maybe you don't have exact the same sybase version on both environments – MarKuz Dec 01 '17 at 09:18
I see, apparently pre und production they are not they have difference verstions. – Enrique Benito Casado Dec 04 '17 at 12:20

1 Answers1