Forum Discussion
Problem with Codepage / Special character viuialisation
Resident RockstarHi Ralfk,
Based on your information, I'm a little confused about your requirement.
Do you want to convert the special character in german to standard character?
I'm not good at Power Query, ImkeF may help you.
In addition, you could share some data sample and your desired output so that we could understand your requirement better and get the solution.
Best Regards,
Cherry
Community ChampionTbh, that's not my strong suit and I also alway play around with different encodings.
Lately I had some cases where 65001 and 1250 worked (I'm sitting in Germany as well).
Otherwise you can try to apply the decoding with an optional parameter in your first import-step already: https://msdn.microsoft.com/en-gb/query-bi/m/db2-database
Hi Imke,
thanks for your reply!
I must adsmit that I have no idea how to implement your advice.....
Is this a function I have to add in the query definition??
query definitionRegards Ralf
- ImkeF
You have to tweak the code where you import from the DB2-database.
Currently it should look like so:
DB2.Database(<YourServername>, <YourDatabasename>)
try adding a "1" in a record at the end:
DB2.Database(<YourServername>, <YourDatabasename>, [BinaryCodePage= 1])
- v-piga-msft
Hi Ralfk,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
