Can XATAFace represent a UTF8mb4 U+000B New Line character in detail view ?

[Mark Lamberson]

 

Question Summary

What UTF8mb4 character code does XATAFace 2.2.0 running on Ubuntu 16.04 LTS PHP7 MySQL 5.7 need to see to display the new line ?

Question Details

Currently, XATAFace record displays MySQL 5.7 “TEXT” field with UTF8mb4 new line code:

http://www.charbase.com/000b-unicode-line-tabulation

What UTF8mb4 character code does XATAFace 2.2.0 running on Ubuntu 16.04 LTS PHP7 MySQL 5.7 need to see to display the line feed like so:

This MySQL installation has been setup for full UTF8mb4 Unicode support, asian characters and the works !

The U+000B New Lines are being inserted upstream in a csv import file from a UTF8 text editor with the thinking that the result of the new line would be displayed, ie. a new line and not just an inline graphic block with 00 0B .

Should I be going about this a different way? Or is there a UTF8mb4 character that will allow XATAFace to depict the newline ?

[Steve Hannah]

Xataface by default uses UTF-8 on the client side.  If the database is set up with a different encoding, it will convert it.

(The config for utf-8 happens here: https://github.com/shannah/xataface/blob/master/Dataface/Application.php#L731-L738)

If these characters are being introduced by a CSV file that you're importing, then I recommend you pre-sanitize it before doing the import.  E.g. http://stackoverflow.com/a/16496799/2935174

Steve

--
You received this message because you are subscribed to the Google Groups "Xataface" group.
Visit this group at https://groups.google.com/group/xataface.
To view this discussion on the web visit https://groups.google.com/d/msgid/xataface/7f8a9a15-df12-4f70-bed1-c376c946d750%40googlegroups.com.

--

Steve Hannah

Web Lite Solutions Corp.