on 2013 Oct 23 2:50 PM
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.
Request clarification before answering.
I found the answer.
In the UTF-8 character encoding, which is what my database uses, CONVERT(NCHAR(1), 0xd7a6, 0 )
works.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
46 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.