cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stan_gifford
Resolver I
Resolver I

STrings in (appently) different character sets.

This is a truly weird issue.

 

I am migrating data from one dataverse to another.

In my flow I use the old Common data service connectory to get the old system data.

I have a table in the old dataverse that I need to get the equivelent value from the new dataverse.

 

Get all values (only three) from old and create a array.

Ditto for new dataverse.

 

When migrating I find the value from the old system (a currency) and using the GUID I look for the value in the first array. From this I get a name. I then use the name to filter in new table to return me the appropriate GUID for when I create a record in the new system.

 

Issue - filter no returning data from new table (filtering on name).

 

CHanged code to do a for each on new array.

String comparisons failed.

 

Here is one string       - Australian Dollar

And here is the other - Australian Dollar

 

It says they are not equal.

 

Tried checking the lengths - both the same.

 

In an act of desperation, I converted bot to base64 and lo and behold I get this;

 

First string      - QXVzdHJhbGlhbiBEb2xsYXI=

Second string - QXVzdHJhbGlhbsKgRG9sbGFy

 

I am fairly sure that the data I have had returned by the OLD CDS connector is returned in utf-8 however the header returned by the CDS (Current environment) does not specifically show me the character set.

 

The front half of the Base-64 seems to be the same with both strings and then they diverge.

 

I thought I sawa string comparison function that I believe essentially compares using a UTF-8 type comparison, but currently have mislaid the link - will keep looking.

 

If anyone can shed some light on the above, I would be truly gratefull.

 

Stan

 

 

 

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,782)