# DynamicWhere string constant serialization changes CRLF to LF in a value

**URL:** https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786
**Category:** Data Abstract
**Tags:** delphi
**Created:** [August 28, 2023, 11:32am UTC](https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786 "2023-08-28T11:32:14Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![edn.user3](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/e/d07c76/32.png) [@edn.user3](https://talk.remobjects.com/u/edn.user3)
#### Post date: [August 28, 2023, 11:32am UTC](https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786/1 "2023-08-28T11:32:14Z")

</div>

Hello,  
I have discovered that the constant value of a DynamicWhere constraint is changed during a transport to a server. The XML seems to still contain CRLF, but the deserialized value contains only LF, which causes the record not to be found (e.g. in a search for a value entered by a user). What can I do about it? Thanks.

Best regards,  
Joe

---

<div class="post-metadata">

### Author: ![mh](https://talk.remobjects.com/user_avatar/talk.remobjects.com/mh/32/18050_2.png) [@mh](https://talk.remobjects.com/u/mh)
#### Post date: [August 28, 2023, 11:36am UTC](https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786/2 "2023-08-28T11:36:11Z")

</div>

This does sound like a bug, yeah.

Of course, this _should_ now matter, but this might help us narrow it down: are both client and server Windows systems, or is the server per chance running on Linux or macOS?

---

<div class="post-metadata">

### Author: ![edn.user3](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/e/d07c76/32.png) [@edn.user3](https://talk.remobjects.com/u/edn.user3)
#### Post date: [August 28, 2023, 11:44am UTC](https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786/3 "2023-08-28T11:44:39Z")

</div>

Yes, both client and server are Windows only.

---

<div class="post-metadata">

### Author: ![RemObjectsSoftware](https://talk.remobjects.com/user_avatar/talk.remobjects.com/remobjectssoftware/32/15947_2.png) [@RemObjectsSoftware](https://talk.remobjects.com/u/RemObjectsSoftware)
#### Post date: [August 28, 2023, 12:20pm UTC](https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786/4 "2023-08-28T12:20:59Z")

</div>

Logged as [bugs://D19385](https://www.remobjects.com/portal/bugs/?id=D19385).

---

<div class="post-metadata">

### Author: ![EvgenyK](https://talk.remobjects.com/user_avatar/talk.remobjects.com/evgenyk/32/16_2.png) [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [August 28, 2023, 12:41pm UTC](https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786/5 "2023-08-28T12:41:55Z")

</div>

Hi,

Looks like, this is a “feature” of MSXML to convert CRLF to LF …

 ![Untitled](https://talk.remobjects.com/uploads/default/original/3X/8/a/8a53743a89c2ae66444ab0aba7dfbce0d7c41ccd.png)

* * *

as a temporary workaround, you can use OpenXML:  
add to `RemObjects_user.inc` these lines:

```auto
{$UNDEF RemObjects_MSXML}
{$UNDEF RemObjects_NextGenXML}
{$DEFINE RemObjects_OpenXML}

```

---

<div class="post-metadata">

### Author: ![RemObjectsSoftware](https://talk.remobjects.com/user_avatar/talk.remobjects.com/remobjectssoftware/32/15947_2.png) [@RemObjectsSoftware](https://talk.remobjects.com/u/RemObjectsSoftware)
#### Post date: [August 29, 2023, 8:18am UTC](https://talk.remobjects.com/t/dynamicwhere-string-constant-serialization-changes-crlf-to-lf-in-a-value/28786/6 "2023-08-29T08:18:58Z")

</div>

[bugs://D19385](https://www.remobjects.com/portal/bugs/?id=D19385) was closed as fixed.
