Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

display japanese characters stored in hex field

Status
Not open for further replies.
George221

George221

MIS
Dec 2, 2005
50
US
I have Japanese characters stored in a field defined as CCSID 65535 (hex) and was wondering what the best way was to display it.
I've tried "select cast(myfield as varchar(360) CCSID 1208 from table1" but this doesn't work. How can I convert this field to display Japanese characters correctly?.
Thanks.
 
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
250
gdg1976
gdg1976
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
145
evr72
evr72
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
126
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
274
ANGELDANY
ANGELDANY
evr72
  • Locked
  • Question
Get last field value into next row
Replies
6
Views
138
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top