56
Views
5
Comments
Solved
[SQL Sandbox]  Special characters are encoded in Error Message
sql-sandbox
Web icon
Forge asset by Leonardo Fernandes

Hi everyone,


I have used SQL Sandbox for a while, and it is fantastic with no doubt.

But recently, the special characters are encoded in the error message. 


With a simple query, you can understand it.


But if the query is more complex, it will be a problem.  Something like this



Any ideas how to fix this? 


Thanks,

Nam

2021-09-06 15-09-53
Dorine Boudry
 
MVP
Solution

Hi @Nam Nguyen ,

the cause can be found in the use of EncodeHTML, if I replace that, the weird characters are gone.

I don't know why that function is used there, so I don't know if it should/can go, but if you do remove it, messages show up normal.

before

after

Dorine

2023-02-20 05-20-57
Nam Nguyen

It works. 
My eyes and brain give you a thank for solving their problem :D

2023-02-09 12-36-42
Damian Fonville

After the select there are no columns defined


SELECT * FROM {User}  should work


2023-02-20 05-20-57
Nam Nguyen

You're not understand the question. It is not about a valid SQL query.

2023-02-09 12-36-42
Damian Fonville

I was a bit to quick in responding, My excuses

2021-09-06 15-09-53
Dorine Boudry
 
MVP
Solution

Hi @Nam Nguyen ,

the cause can be found in the use of EncodeHTML, if I replace that, the weird characters are gone.

I don't know why that function is used there, so I don't know if it should/can go, but if you do remove it, messages show up normal.

before

after

Dorine

2023-02-20 05-20-57
Nam Nguyen

It works. 
My eyes and brain give you a thank for solving their problem :D

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.