0

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?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Vicc
  • 1
  • 2
  • Encoding is mostly transparent in SQL Server (you'll get the same string on the client end no matter how the characters are encoded), so it's not clear what your scenario is. Doubly so because Windows-1251 cannot encode any Chinese characters. Do you want to change the column collation? – Jeroen Mostert Aug 31 '22 at 07:15
  • `nvarchar` would probably be a better idea – Charlieface Aug 31 '22 at 10:33

1 Answers1

0

You can add a "data conversion" component, and then you can select the code page for it

Baldie47
  • 1,148
  • 5
  • 16
  • 45