Handling Chinese Characters in Queries When Accessing AZURE SQL

 select Name from Customer Basic Information where Name = 'Kanji'

If so, the result is zero.

On the AZURE SQL management site

 select Name from Customer Basic Information where Name = N 'Kanji'

If you add N before the kanji as shown in , the result will be returned.
Access queries result in syntax errors.

In the same query on the Access side

select Name from Customer Basic Information where Name = strconv('Kanji',64);

However, the result is zero.

If you know how to search for kanji data in the query on Access side, please let me know.
I look forward to your kind cooperation.

2022-09-30 20:29

1 Answers

I don't know how I connected with Access, but I could get it from ODBC data source as long as I ran a query through the link table.

I don't know if it will be helpful, but I will write down the details.

Provider SQL Server Native Client 11.0
If it is a Native Client, there should be no problem.
Change the default database to: but keep it normal

Create with the following sql on Azure Management Portal

create table customer base information (id int primary key, name nvarchar(32))

Details are as follows

Enter a description of the image here

select Name
FROM dbo_Customer Basic Information
where name = 'Kanji'

access1
access2

2022-09-30 20:29

Popular Tags

python x 4647

android x 1593

java x 1494

c x 927

c++ x 878

php x 692

html x 656