×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
For posterity sake, here's what I ended up with:
select CUSNO,CAST(CUSNM AS CHAR(30) CCSID 935) as CUSNM from table1
This accurately converted the file from 65535 to simplified Chinese. CCSID 935.
This worked perfectly with the Client Access ODBC driver.
From: Richard Schoen
Sent: Thursday, March 22, 2018 4:13 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Quick DBCS Conversion with SQL Query Question
Hey All,
Quick question for your DBCS users.
I need to query a database table where there is Simplified Chinese data stored in a field coded 65535.
How do I convert that data to PC format during my SQL query for insert to SQL Server in PC format ?
I seem to recall applyid the CCSID somewhere during the SQL statement on a column that needs to be converted, but it's been a while and the google isn't yielding anything yet.
Any thoughts or examples appreciated.
Thanks in advance.
Regards,
[
http://static.helpsystems.com/hs/email/templates/signatures-final/images/hs-logo2.png]
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx<mailto:richard.schoen@xxxxxxxxxxxxxxx>
p. 952.486.6802
w. helpsystems.com<
http://www.helpsystems.com/>
[cid:image002.jpg@01D1A545.4C2BF250]<
http://www.linkedin.com/in/richardschoen>[cid:image003.jpg@01D1A545.4C2BF250]<
http://www.twitter.com/richardschoen>
midrange.com
