RE: Quick DBCS Conversion with SQL Query Question

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>