TD-4181: Oracle problem

[DocData3d]

I have a table defined with a VARCHAR2(4000).

If I SELECT that column into a long string, I get garbage .

If I SELECT into a string, I get nothing.

The SQL is...
SELECT SCODES FROM SCSECGROUP
WHERE GROUP_NAME IN (SELECT SECGROUP FROM GRPMBRS WHERE USER_ID = :sUser)

and sUser = 'DBS"

The content of the column is "1|2|3|4|5|6|9|15|17|19|20|21|22|30|40|50|60|70|81|82|90|91|" as seen in a SQLTalk query.

What's up with this?

Dave

[Jean-Marc Gemperle]

Hi Dave,

Yes sorry..
You have to use long string anyway...now as you noted there is problem UTF8 are returned for long string instead. TD-4181.

JM