The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

BAD Encoding from manual input (Streambase 10.6)

zachi_sharonzachi_sharon Community Edition User

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.

Tagged:

Comments

  • moshegmosheg Vertica Employee Administrator

    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)
    

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file