Character set problem?

Hi *,

I'm trying to find a solution for a few days right now... Maybe someone has a solution?

On a oracle 9i i have a table (some on 8i):

SQL> desc archiv1.objekte

 Name                                      Null?    Typ
 ----------------------------------------- --------
----------------------------
 OBJTYPE                                   NOT NULL NUMBER(38)
 OBJID                                     NOT NULL NUMBER(38)
 OBJSHORT                                           VARCHAR2(50)
 ....
 OBJACL                                             VARCHAR2(242)

the interesting fields are OBJSHORT and OBJACL

if i insert an row, with the values 'aa\ff' into the two fields, theres is no problem with OBJSHORT but with OBJACL.

i figured out right now a problem with the character set:

WS8ISO8859-P1 and WS8ISO8859-P15
OBJSHORT is OK, OBJACL value is 'aa' + ascii(191)

WE8MSWIN1252
OBJSHORT is OK, OBJACL value is 'aa' + ascii(129)

on a ms-sql behaviour is like MSWIN1252

i'm wondering about the difference with the ISO character set and the two fields in one row.

the insert statement is:
insert into ARCHIV1.objekte
(objtype,objid,objflags,objshort,...,objacl,replset) values (1,22,1073741825,'aa\ff',...,'aa\ff','')

Any ideas

Michael Received on Tue Jun 25 2002 - 03:07:27 CDT