Thanks I kind of figured that out, but when you got text to blob, you can not choose character set. According to docs. see below. How would one solved this problem. I wiuld guess continues to use send packet is omne solution. Are there others.
Regards Chuck Text without length The text is composed only of its characters. *UTF8* "" --> No data "Café" --> $43 61 66 C3 A9 *Mac* "" --> No data "Café" --> $43 61 66 8E On Tue, Oct 30, 2018 at 12:40 PM John DeSoi via 4D_Tech < [email protected]> wrote: > The problem is likely with TEXT TO DOCUMENT/Document to text. These have > strange defaults, so you have to be very careful about the parameters. > > TEXT TO DOCUMENT defaults to UTF-8 and inserts a BOM (which I think is a > bug). So you can't read it using DOCUMENT TO BLOB and covert to UTF-8 text > without deleting the BOM first. > > Document to text assumes MacRoman/ANSI if the document does not have a BOM > and you don't specify the character set. So if you are saving UTF-8 with a > blob, you need to be sure to specify the character set for Document to text > to interpret it correctly. > > John DeSoi, Ph.D. > > > > On Oct 30, 2018, at 11:09 AM, Charles Miller via 4D_Tech < > [email protected]> wrote: > > > > When I use text to blob with utf 8 > > conversion and then blob to document or text to document the bullets get > > converted to strange looking question marks. Any idea how to solvce this > > problem. I know it has something to do with character set but UTF8 text > > without length does not work. > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- ----------------------------------------------------------------------------------------- Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity http://www.informed-solutions.com ----------------------------------------------------------------------------------------- This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
