ANSCI code view from SQL data

Question

ANSCI code view from SQL data

Murphy'sLaw

Right there with Babe

Points: 725
More actions
April 1, 2012 at 3:03 pm

#253364

Does anybody have any experience/ideas on converting SQL data (Unicode) to ANSIC. I am told that this can be done in SSIS or TSQL. I needed to build ANSCI code view from SQL data. i will appreciate any inputs.thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 1

Please clarify your requirement with examples of the data held and the output required. The original post stated both ANSCI and ANSIC, neither of which I have come across before.

Fitz

Murphy'sLaw Right there with Babe Points: 725 More actions · Answer 2

Mark Fitzgerald-331224 (4/2/2012)
Please clarify your requirement with examples of the data held and the output required. The original post stated both ANSCI and ANSIC, neither of which I have come across before.
Fitz

Well the scenario is that I need to extract data from SAP system which has data residing in the Unicode format and my client's requirement is that , data be converted to ANSI downstream. I understand that there is a mechanism to create ANSI views of Unicode data or may be just convert it to ANSI either in SSIS or TSQL. I am thankful to any inputs.

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

I think you mean ASCII not ANSI???

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jared SSC Guru Points: 61793 More actions · Answer 4

Sean Lange (4/3/2012)
I think you mean ASCII not ANSI???

What Sean is saying here is that ANSI is not a results type, it is a standard. ASCII is a character set.

Jared
CE - Microsoft

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

Try taking a look at this link. There is no reason you can't handle UNICODE data in sql server. Keep in mind there are not always direct translations from UNICODE to ASCII.

http://msdn.microsoft.com/en-us/library/ms176089.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Murphy'sLaw Right there with Babe Points: 725 More actions · Answer 6

SQLKnowItAll (4/3/2012)
Sean Lange (4/3/2012)
I think you mean ASCII not ANSI???
What Sean is saying here is that ANSI is not a results type, it is a standard. ASCII is a character set.

In that case, when doing a unicode conversion in SSIS using Data Conversion or Derived column into [DT_STR] codepage 1252 Ansi, the output string is ASCII, right?