Warning: Table '.\dcgforum\cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://forums.dataphor.org/index.php?q=node/25' in C:\Sites\DCGForum\includes\database.mysql.inc on line 172
IsLetter/Digit in Oracle | Dataphor Forums

IsLetter/Digit in Oracle

The mappings for IsDigit(), IsLetter() and IsLetterOrDigit() for Oracle don't work correctly, since Oracle's LIKE doesn't support regular expressions. REGEXP_LIKE might be used instead (at least for Oracle 10 and later).

Jon

Defect Reported

Hi Jon,

Thank you for the suggested alternative, I have added this to the defect list.

Bryn Rhodes
Database Consulting Group LLC


Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: LOCK TABLES cache_page WRITE</em> in <em>C:\\Sites\\DCGForum\\includes\\database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://forums.dataphor.org/index.php?q=node/25', '', '54.196.190.32', 1542387827) in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: UPDATE cache_page SET data = &amp;#039;\\0\\0\\0\\0\\0\\0Xn6pb\\0i;M5IlZ֡(Z%\\&amp;quot;чl\\&amp;#039;!uXDsΧ n:&amp;lt;1&amp;amp;קC|B~9$޾8{9^ o!2;T9;%VP,v: ѭStTH=@4\\Zz,AhF866:cf SG\\0Oᕢ`QCX*x&amp;amp;U)vf(XS|!糡w(SR-2AP\\r=.\\r= J33󀌶z\\Z5 GpbӡG\\\\0M\\&amp;quot; l/3xB#F.bti#+$,tQ!&amp;lt;P!x$an2dұ 6~0І%$dS oPdssa69R\\\\oB\\\\ ӧ&amp;amp;f2\\n\\&amp;quot;H@\\n*~޴;[/Z2Ssn-۾OA in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Incorrect string value: &amp;#039;\\x8B\\x08\\0\\0...&amp;#039; for column &amp;#039;session&amp;#039; at row 1\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;tmvgv2lgd6h916280vv94t47m1&amp;#039;, 0, 0, &amp;#039;54.196.190.32&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:195:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is marked as crashed and should be repaired\\nquery: LOCK TABLES cache_page WRITE in C:\\\\Sites\\\\DCGForum\\\\includes\\\\database.mysql.inc on line 172.\\&amp;quot;;i:1;s:2281:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is mark in C:\Sites\DCGForum\includes\database.mysql.inc on line 172