CodePage P850

Hi team,

I'm getting information from a database, this database was started with Codepage P850. I'm using the ConvertfromCodePage with code=850 but is not working. Do you know what I can do in this case?

Original content:

After applying the formula:

Rgds

Eduardo

Input

Transformation

Database Connection

Accepted answers

AZuc

@eduardomarchesin take a look on these links

https://www.connectionstrings.com/sybase-adaptive/ look for CodePageType

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20116.1550/html/aseodbc/CHDEBHJF.htm

https://knowledgebase.progress.com/articles/Article/3132

All comments

Luke_C

Hi @eduardomarchesin

Based on the below page, 850 doesn't seem to be a supported value. Can you post some sample data?

Code Pages | Alteryx Help

eduardomarchesin

Hi Luck_C,

Thank you for your answer!!

I've included in my previous post the examples.

Let me know if you need another type of example.

Rgds

Eduardo

Luke_C

@eduardomarchesin I meant a non-screenshot, hard to type those values to replicate the issue 🙂

eduardomarchesin

HI Luck_C,

I got it..

Please find below the examples, these description coming from directly of the database..

Pacote ContÃŸbil - CTD
ContÃŸbil Start

Rgds

Eduardo

Luke_C

Hi @eduardomarchesin

Possible the community supports a different encoding. Have you tried the 'DecomposeUnicodeForMatch' function? Seems to be getting a result but not sure if it makes sense based on your data. Only downside is it makes everything lowercase.