#DateForumTypeThreadPost
1118 Mar 2016 @ 03:53 PDTGeneralReplyError 6706 The string contains an untranslatable characterHi Dieter, I ended up using TRANSLATE(varchar_field USING UNICODE_TO_LATIN WITH ERROR) to run the code without it erroring out. What are the disadvantages to using this as a workaround?
1016 Mar 2016 @ 07:42 PDTGeneralReplyError 6706 The string contains an untranslatable characterHi Dieter, I have a couple of issues when trying this. 1. I don't have permissions to create functions 2. I couldn't locate 'udf_utf16to8' in that github
916 Mar 2016 @ 06:30 PDTGeneralTopicError 6706 The string contains an untranslatable characterI'm running a query in Tera mode.  My query looks something like: select * from dwh.tablename where SHA256('ph5p6uTezuwr4c8aprux' || stringfield ) = '480b1ec07f9e5...
817 Jun 2015 @ 05:05 PDTGeneralTopicUnderlying table contains all bad fields 'The format or data contains a bad character'I have an unusual sitution. The below query works when I don't refer to any of the fields in the 'product_table'. If I leave the product table join in it still works so it's not an...
712 Jun 2015 @ 09:16 PDTGeneralReplyFinding a substring between two pointsapologies, the adjusted function looks like   regexp_substr(fullurl ,'(?<=(\?page_id\=|/page_id/))(.*?)(?=\&)' ,1 ,1, 'i')
612 Jun 2015 @ 08:17 PDTGeneralReplyFinding a substring between two pointsThanks Dieter, I hope you don't mind, I have a little additional question What if I wanted to find more than on variant, could this work regexp_substr(field_text ,'(?<=\?[page_id|shop_...
511 Jun 2015 @ 09:38 PDTGeneralTopicFinding a substring between two pointsI have  a string which looks like  "/channel/featured?page_id=this_is-the_text-that_I_want&rest_of_the_query" I'm trying to extract just 'this_is-the_text-that_I_w...
429 Apr 2015 @ 05:10 PDTAnalyticsTopicCast Seconds (Data type HS) too Hour:Minutes:Seconds Time data typeI have a time stored in HS format. So the time will look like '0 20:50:00.000000'. I need to convert this to the data type time.  When I simply try to  cast(HStime to time) I...
326 Apr 2015 @ 04:18 PDTAnalyticsReplyFind average time of dayHi Dieter, Your second code snippet is very helpful. I've added minutes and it's coming back with the expected results. In regards to the distance, I didn't explain that well. I'...
225 Apr 2015 @ 05:34 PDTAnalyticsReplyFind average time of dayHi Dieter, I've been looking into this more and I have a workaround which involves a time reference table. There are points in a plot which map out 1-24 hours in a circle. The x and y values...
125 Apr 2015 @ 06:34 PDTAnalyticsTopicFind average time of dayI have code with hours of day. I want to find the average of day but if one time is hour 22 another is 2 then the average with be 12 noon but I want to get 0 midnight as it is the closest time betw...