{{tag>category:"OpenInsight 32-bit" author:"Mike ONeal" author:"Andrew McAuley" author:"Donald Bakke"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== OSREAD and accented characters (OpenInsight 32-bit) ====
=== At 18 SEP 2020 03:15:14PM Mike ONeal wrote: ===
 
 
<QUOTE>
Hello all - I am importing a text file using OSREAD and am having trouble with accented characters becoming garbled.  If I know what the garble is (easy to see when switching encoding between UTF8 and ANSII in a text editor), for some characters I can do a simple swap before writing the data.  This works:



swap "é" with "é" in all

swap  "Ã" with "à"  in all

swap "À" with "À" in all



Some characters however fail, such as:

swap "É" with "É" in all

Swap "Æ’" With "ƒ" in all



I have also tried using CHAR() equivalents on these swaps.

The users are able to enter these "failing" characters directly via their keyboards with no problem.

OI94, ANSII system / toggling to UTF8 mode is not at this time an option.

Any ideas?

Thanks much,

Mike O.


</QUOTE>
----

=== At 18 SEP 2020 04:14PM Andrew McAuley wrote:  ===

<QUOTE>There are multiple routines provided to support this sort of operation.



I am currently away from my computer, but check the help for (what I believe is called) UTF8_TO_ANSI.



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 18 SEP 2020 04:21PM Donald Bakke wrote:  ===

<QUOTE>
<QUOTE>...toggling to UTF8 mode is not at this time an option.</QUOTE>



To clarify, do you mean it is not an option to toggle the application as a whole for this or is not an option to use the SetUTF8() subroutine for this?



Is the end goal to make sure all UTF8 characters are converted to ANSII so the desktop users can see the data in a somewhat readable manner?



[url=mailto:dbakke@srpcs.com]Don Bakke[/url]

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]

</QUOTE>

----

=== At 19 SEP 2020 09:43AM Mike ONeal wrote:  ===

<QUOTE>Thanks Andrew - I should have known that!

Don, at some point (soon...) I need to convert their ANSII system to UTF8 and toggle over to UTF8.  This exercise is just to get a data file into their system in legible format.  I already know some characters will not convert.  Mike

</QUOTE>

----

=== At 19 SEP 2020 09:59AM Andrew McAuley wrote:  ===

<QUOTE>We did a [url=https://sprezzblog.blogspot.com/2018/10/]blog post[/url] on this as we had to undertake the exercise for someone who had a mixed UTF8/ANSI database. They'd allowed users to cut and paste from web sources so their data was riddled with bits of UTF8. There are a number of technical challenges but I think we covered them all.



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=4495583C3B64EC4498697EC707C2138E|View this thread on the Works forum...]]