SQL json query generated does not support Chinese fonts

    CREATE TABLE "DBA"."web_print_name" (
    "name" VARCHAR(10) NOT NULL,
    "no" NCHAR(10) NULL,
    PRIMARY KEY ( "name" ASC )
) IN "system";

INSERT INTO "DBA"."web_print_name" ("name","no") VALUES('陈二','002');
INSERT INTO "DBA"."web_print_name" ("name","no") VALUES('刘一','001');

--SQL:

SELECT name,no   FROM "DBA"."web_print_name" for json raw

alt text

Is this a utf-8 encoding problem? How should it be solved? thanks

sa-17

asked 04 Jun '21, 11:57

mfkpie8
238●64●69●72
accept rate: 12%

edited 04 Jun '21, 11:57

flat view

One Answer:

active answers oldest answers newest answers popular answers

0	This may be relevant: https://sqlanywhere-forum.sap.com/questions/32972/problem-with-for-json-raw-and-character-sets permanent link answered 04 Jun '21, 13:43 Justin Willey 7.5k●136●177●247 accept rate: 19% Are there any fixes for the new version? (05 Jun '21, 01:42) mfkpie8 flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

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

learn more about Markdown

Question tags:

sa-17 ×222

question asked: 04 Jun '21, 11:57

question was seen: 399 times

last updated: 05 Jun '21, 01:42

SAP SQL Anywhere

SQL json query generated does not support Chinese fonts

Follow this question

Related questions