Ayende @ Rahienhttp://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Sina commented on Strange production errorsThis is a quite valid and common character in some languages, such as Persian (it is called Zero-Width Non Jointer) and joins different parts of a single word, when you don't want it get separated when word-wrapping happens. E.g., the following word contains a ZWNJ: می‌روم Since it is a very common character for some languages it may happen usually that somebody changes the keyboard language accidentally and enter it without purpose. http://ayende.com/153761/strange-production-errors#comment7http://ayende.com/153761/strange-production-errors#comment7Fri, 04 May 2012 12:28:03 GMTKhalid Abuhakmeh commented on Strange production errorsSo when is RavenVM coming out?http://ayende.com/153761/strange-production-errors#comment6http://ayende.com/153761/strange-production-errors#comment6Fri, 04 May 2012 11:38:42 GMTMatt commented on Strange production errorsI get this quite a lot in our databases. The source is usually legacy processes that rely on Excel spreadsheets/vba for data loading (yuck).http://ayende.com/153761/strange-production-errors#comment5http://ayende.com/153761/strange-production-errors#comment5Fri, 04 May 2012 09:52:23 GMTMikkel Christensen commented on Strange production errorsAnother problem to watch out for when using the MailAddress constructor: http://social.msdn.microsoft.com/forums/en-US/netfxnetcom/thread/2217c413-968f-4dcf-8035-45eaf2a3c609 http://ayende.com/153761/strange-production-errors#comment4http://ayende.com/153761/strange-production-errors#comment4Fri, 04 May 2012 09:26:21 GMTNic Wise commented on Strange production errorsWe've just been dealing with something similar. select id, catnum from table; 1 ABCD-1234 2 ABCD-1234 select id, '[' + catnum + ']' from table; 1 [ABCD-1234] 2 [ABCD-1234 (catnum is ment to be unique, too!) Got some unicode nonsense going on in there somewhere.... I suspect a newline, but we still can't find it.http://ayende.com/153761/strange-production-errors#comment3http://ayende.com/153761/strange-production-errors#comment3Fri, 04 May 2012 09:17:01 GMTItamar commented on Strange production errorsThis usually happens when you copy-paste from Word. That guy isn't too sophisticated, he is just lazy...http://ayende.com/153761/strange-production-errors#comment2http://ayende.com/153761/strange-production-errors#comment2Fri, 04 May 2012 09:11:34 GMTPhil Jones commented on Strange production errorsHoly crap! I just debugged the exact same issue on my client's system. We were all similarly scratching our heads till I had to use to view source. My solution: // Remove HTML characters email = Regex.Replace(email, "&#[0-9]+;", ""); (A big hacky)http://ayende.com/153761/strange-production-errors#comment1http://ayende.com/153761/strange-production-errors#comment1Fri, 04 May 2012 09:11:33 GMT