Re: Unicode stuff [XPA2.5 - SQL]

Florian Groothuis

I deleted this topic. It’s solved.


Met vriendelijke groet - With kind regards,

Florian Groothuis
+31 (0)6 21927914

Meilink Beheer Borculo B.V. • Kamerlingh Onnesstraat 1
7271 AZ  Borculo • Nederland • +31 (0)545 253525
KvK 08009803 • Our general terms and conditions apply • Disclaimer

Van: [] Namens Govert Schipper
Verzonden: vrijdag 16 juni 2017 18:24
Onderwerp: Re: [magicu-l] Unicode stuff [XPA2.5 - SQL]




This is strange indeed, shouldn't make a difference. 

So the alpha field with length 3 is a virtual? And is it also a Unicode field, or an Alpha?



Van: <> namens Florian Groothuis <f.groothuis@...>
Verzonden: vrijdag 16 juni 2017 10:58
Onderwerp: [magicu-l] Unicode stuff [XPA2.5 - SQL]


We have tables with field of type Unicode. In my application I have an alpha field with a length of 3. I try to do a locate on a table with a trim() on that field with an additonal text:


This returns NULL()

When I skip the trim:


it works fine. How come?

In both cases the field was completely filled as 'SCH', so the trim was obsolete but what if.....?

Join to automatically receive all group messages.