We're using SQL Anywhere 12 as an embedded database in our application. As such, when we install our application on client systems, we don't do a full SQL Anywhere install. In fact, the only tool that we install that can run SQL scripts is dbisqlc.exe.

We have a salesman who is in Israel to do a demo. In preparation for that demo, I created a SQL script file that adds some special rows to our state table. One of these rows contains Hebrew characters.

I wrote the script using dbisql.exe. I also wrote a batch file to execute that script using dbisqlc.exe. I found that dbisqlc ignores the code page setting on the file and the row in the state table that should have Hebrew characters has gibberish instead.

How do I get this script to work?


The Hebrew character I need is called "Tsadi" and is HEX 05E6.

asked 23 Oct '13, 13:50

TonyV's gravatar image

accept rate: 75%

edited 23 Oct '13, 14:05

I found the answer.

In the UTF-8 character encoding, which is what my database uses, CONVERT(NCHAR(1), 0xd7a6, 0 ) works.

permanent link

answered 23 Oct '13, 14:36

TonyV's gravatar image

accept rate: 75%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 23 Oct '13, 13:50

question was seen: 2,993 times

last updated: 23 Oct '13, 14:36