Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2005-06-28 : 21:00:41
|
| Dear All, There is a field storing ansi character. Is there any method to convert this field to unicode (Chinese) and from unicode to ansi using DTS? Thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-28 : 22:41:58
|
| Is the field storing an ansi character, or an ansi code?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2005-06-29 : 09:52:02
|
Ansi character - big5 code.The field is ordinary varchar.quote:
Originally posted by derrickleggett
Is the field storing an ansi character, or an ansi code?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
|
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-29 : 15:07:11
|
| Ok. There are no ANSI characters for Chinese (please feel free to correct me on this, as I might just be an idiot). Converting ANSI to Unicode would just give you the unicode equivalent of the ANSI character. It's an automatic conversion. Why don't you give us an example of the data you currently have in these VARCHAR fields and show us what you want it to look like in as an NVARCHAR (unicode). It doesn't really make sense to have ever stored the data in non-unicode format.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
TimS
Posting Yak Master
198 Posts |
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2005-06-30 : 09:24:52
|
Perhaps I have made a mistake in telling the problem.The database stores big5 chinese character and accented characters in two different fields. The application accessing these data does not support unicode. However, there are times when these data will be exported to other databases. This may support unicode and it would be good to do the transport/export using DTS without writing an application program to do so. Is there any way to do this?quote:
Originally posted by derrickleggett
Ok. There are no ANSI characters for Chinese (please feel free to correct me on this, as I might just be an idiot). Converting ANSI to Unicode would just give you the unicode equivalent of the ANSI character. It's an automatic conversion. Why don't you give us an example of the data you currently have in these VARCHAR fields and show us what you want it to look like in as an NVARCHAR (unicode). It doesn't really make sense to have ever stored the data in non-unicode format.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
|
|
|
|
|
|
|
Unicode <-> Ansi conversion in DTS