I have done some testing with Japanese customer names with VARCHAR columns and Latin1_General_100_CI_AS_SC_UTF8 collating in SQL Server 2019. This works perfectly with the SSMS and Excel import from SQL Server. According to Google translate I don't loose information. In the example below the Name is the Japanese name and Address the English name.

I am really looking forward to the first preview/alpha version of NextGen to test with DataFlex.

Click image for larger version. 

Name:	SQL Japan.jpg 
Views:	55 
Size:	138.3 KB 
ID:	13124