JuanPa
28th January 2022, 21:39
Dears

I am storing a text field using an external editor (notepad.exe) but Polish characters are not well stored (attach example). It works well with the standard text editor.

I was searching solutions here (http://www.baanboard.com/baanboard/showthread.php?t=24740) but I could not find it.

Do you have any piece or advice to solve this issue? Which other information I should mention?

Best regards

OmeLuuk
3rd February 2022, 11:29
There is more to this issue than meets the eye at first glance.
There is the interface (where you edit text with notepad, so I assume you do not use LNUI but native BW or such?
So there is conversion of "strange" characters all over the place.
From database character set and collation to the UI (uses TSS), OS characterset, presentation on the screen in the session, then to notepad (again TSS to OS characterset) en from notepad back (OS characterset to TSS) and into the database. Just to name a few.
Then there were changes in the way conversion is done and issues where setup (database driver conversion and UI conversion) was not always in line.

We encountered an issue with the € (Euro sign) in one of our item code (tcibd001.item) that caused internal errors. Dropped the incident with Infor Support and they suggested a complete database conversion and fixed setup. Because of the recent extra changes our setup was outdated and faulty.

Suggestion - Ask experts from Support.