Invalid character value for cast specification

Help Studio
, ,
1

i have a sqlstr to run “select ‘항’”,retrun error:ERROR [22018] [ma-3.1.19][10.3.31-MariaDB-0+deb10u1-log]Invalid character value for cast specification

2

Hi @fzp8633718 ,
Can you share full your string ?
I think : select … from = “N’‘항”
regards,

3

error happened on my first use insert string:“insert ‘항’ into table(filename)”,and i get the same error in “select ‘항’”

4

Hi @fzp8633718 ,

Assuming you are using a SQL Syntax, you could check the Syntax for INSERT query below :

5

Those aren’t proper SQL insert nor select queries.

6

but i do not use the korea charactor,contains other korea charactor,the sql string can process with no error