cancel
Showing results for 
Search instead for 
Did you mean: 

Need to insert a string with a special character into a column using dbisqlc.exe

Former Member
3,546

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?

EDIT:

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

I found the answer.

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

Answers (0)