BAD Encoding from manual input (Streambase 10.6)

zachi_sharon

Hi all,
Trying to enter non-ascii string (say in hebrew language) via Text field on "Manual Input" wizard (Streambase studio 10.6) - ends up on code side with invalid string - how can I fix that?
Thanks,
Zachi.

mosheg

Hi Zachi,
Can you try the following in vsql?

drop table if exists my_table cascade;
create table my_table (f1 int, f2 varchar(80));
copy my_table
from STDIN
delimiter ','
no escape
abort on error;
1,b'\n\\\x7f\xb5'
2,Hebrew letters: אבגדהוזחטיכלמנסעפצקרשתb'\n\\5F'
3,b'\n\\m\xee'
4,b'\n\\}M'
5,"b""\n\\\xd9'"""
6,"b'\n\\n""'"
\.

select * from my_table;
 f1 |                       f2
----+-------------------------------------------------
  1 | b'\n\\\x7f\xb5'
  2 | Hebrew letters: אבגדהוזחטיכלמנסעפצקרשתb'\n\\5F'
  3 | b'\n\\m\xee'
  4 | b'\n\\}M'
  5 | "b""\n\\\xd9'"""
  6 | "b'\n\\n""'"
(6 rows)