Vicc
Reputation: 1
Convert text value in SQL Server from GB2312 to WINDOWS-1251
I have a column in SQL Server with GB2312 Chinese_PRC_CI_AS encoding. How can I convert and save the text in WINDOWS-1251 encoding? I would like to do thing in a query on SQL Server. Any tips?
Upvotes: 0
Views: 264
Answers (1)
Baldie47
Reputation: 1274
You can add a "data conversion" component, and then you can select the code page for it
Upvotes: 0
Related Questions
- How to convert Binary data to text data?
- How to get the original binary value back to string
- Convert nvarchar with hex string to binary
- Convert binary to varchar
- String conversion in sql server
- convert text string to hexadecimal representation or binary representation
- Convert column nText to nvarchar(1026)
- Convert nvarchar data to decimal
- how to convert to specific value when input is in binary string format
- Need to Convert Binary to NVARCHAR IN SQL Server 2008