Skip to Content
author's profile photo Former Member
Former Member

Displaying Δ in hdbsql

Hi all,

I've got a SELECT that returns Δ (U+0394) both in a column name and value. Studio works fine, however in hdbsql I get the error

* -10427: Conversion of parameter/column (5) from data type VARCHAR1 to ASCII failed

and neither -resultencoding nor -B have any effect on this. Has anyone any idea how to make this work? I'm even not interested in the result, I only want the execution time, so throwing out the selected tuples would be fine.

Cheers,

-- Micha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2013 at 07:45 PM

    Hi Micha,

    You can use the UNICODE and NCHAR functions for the Δ logo (Unicode 916), although in the hdbsql (for MS DOS - I'm guessing it depends on the fonts), it will show up as the other Delta Greek character: δ

    Here are the screenshots from HDB Studio and HDB SQL for comparison:

    Regards,

    Ferry


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 06:09 AM

    Hi Micha,

    I am guessing, based in the info provided, that you are binding an ASCII based parameter to an NVARCHAR column, and this is the source of the problem. Try replacing with a Unicode based parameter.

    Regards,

    David

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.