Kbase P148707: SQL statement is malformed when using non-UTF-8 client with MS SQL DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/07/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL statement is malformed when using non-UTF-8 client with MS SQL DataServer
More than one extended character is inserted in an ABL query, via a client session.
Client session is started with -cpstream -cpinternal different than UTF-8
The SQL statement generated by the DataServer engine is appended with additional trailing, random characters.
Running the query generates runtime errors
37000:[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark after the character string ''.
37000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ''.
FACT(s) (Environment):
Windows
OpenEdge 10.1C00
OpenEdge 10.1C01 Service Pack
OpenEdge 10.1C02 Service Pack
OpenEdge 10.1C03 Service Pack
OpenEdge 10.2A00
MS SQL DataServer
CAUSE:
Bug# OE00186215
FIX:
Upgrade to 10.2A01 or later.
Alternatively, start the client session using -cpinternal utf-8 -cpstream utf-8