Kbase P160465: Simple for each query shows only first character of the record when running against MS SQL Server D
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/21/2010 |
|
Status: Unverified
SYMPTOM(s):
Simple for each query shows only first character of the record when running against MS SQL Server DataServer
Dumping the .d using data administration tool also shows single a single characters on the file
Exporting the records from the MS SQL Server shows all the records
FACT(s) (Environment):
From the t-sql on the MS SQL Server all records are shown correctly
The data types for the fields are unicode type such as nvarchar
The schema holder and the schema image is set to iso8859-1
The GUI client started with iso8859-1 code page
OpenEdge 10.2B
MS SQL DataServer
Windows Server 2008
MS SQL Server 2008
CAUSE:
The GUI client and the schema holder and schema image are set to iso8859-1 code page.
FIX:
In order to resolve this issue use the following steps:
1. Create an empty database using the %DLC%\prolang\utf\empty using the following command on the start > All programs > OpenEdge > proenv:
proenv>prodb sh %DLC%\prolang\utf\empty
2. Start the GUI client (prowin32.exe) with -cpinternal and -cpstream set to utf-8 as
proenv>prowin32 sh -cpinternal utf-8 -cpstream utf-8 -1 -p _admin
3. Create MS SQL Server DataServer Schema from the DataServer menu. make sure to change the code page to utf-8 on the Create/Modify database Record for MSS schema" screen. This is very crucial as failing to change will still cause the same symptom.