Use special chars in ASP classic SQL query

Asked Apr 02 '21 at 10:41

Active Apr 02 '21 at 10:41

Viewed 28 times

I have several records in my db (mssql) that contains § inside them.

I query my db as such :

        squery = "SELECT .... WHERE ....= '...§...'"
        AdoCmd.CommandText = sQuery
        AdoCmd.CommandType = 1
        Set AdoCmd.ActiveConnection = OBJdbConnection
        rsado.open AdoCmd,,1,2

However checking via the profile i see that the request is sent with Â§ (which does not math my record obviously)

The solutions i've found only talk about the object repsonse and not the sql query

asked Apr 02 '21 at 10:41

CharybdeBE

1,619
22
31

You need to use an `nvarchar` literal, not a `varchar` literal. `N'§'` not `'§'`. – Larnu Apr 02 '21 at 10:43
The non accepted answer was the solution for me – CharybdeBE Apr 02 '21 at 11:31
@CharybdeBE Amazing, both answers mention adding ` – user692942 Apr 02 '21 at 12:00

Use special chars in ASP classic SQL query

0 Answers0