IsLetter/Digit in Oracle

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

Mon, 10/27/2008 - 12:27 — heggland

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

Dataphor Support Group

Fri, 03/06/2009 - 22:57 — Bryn

Defect Reported

Hi Jon,

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

Bryn Rhodes
Database Consulting Group LLC

All new posts should be made to https://databaseconsultinggroup.zendesk.com/hc/en-us

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', 'Table &#039;.\\dcgforum\\cache_page&#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.', 2, '', 'http://forums.dataphor.org/index.php?q=node/25', '', '54.198.92.22', 1552962250) 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', 'Table &#039;.\\dcgforum\\cache_page&#039; is marked as crashed and should be repaired\nquery: UPDATE cache_page SET data = &#039;�\\0\\0\\0\\0\\0\\0�X�n�6��p�b�\\0�i;M��5I�l�Z�֡(Z�%\\&quot;��ч��l��\\&#039;�!u��X�D��s�Χn�:&lt;��1�&amp;��ק�C�|B~�9$��޾8{9�^�o��!��2��;�T9;%�VP��,��v�:� �ѭ��St��T�H��=��@�4\\Zz,��A�h�F86�6:�cfS�G�\\0Oᕢ�`�QC�X*x&amp;U��)v��f(XS|�!糡w(S�R�-2�AP�\\r=�.\\r��=� �J33��󀌶��z\\Z5� Gp��bӡG�\\\\0M\\&quot;�� l/�3�xB#F.�b�t�i��#+��$,�t�Q!��&lt;�P!x$�an��2d�ұ��6~�0�І%$dS��oPd�ss�a��6�9R\\\\oB\\\\ �ӧ��&amp;f�2�\\n�\\&quot;�H�@\\n�*�~��޴;�[/��Z2�Ss��n�-��۾��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', 'Incorrect string value: &#039;\\x8B\\x08\\0\\0...&#039; for column &#039;session&#039; at row 1\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&#039;qd045rf526v9qsjs8pnl7f7kq5&#039;, 0, 0, &#039;54.198.92.22&#039;, &#039;messages|a:1:{s:5:\\&quot;error\\&quot;;a:2:{i:0;s:195:\\&quot;user warning: Table &amp;#039;.\\\\dcgforum\\\\cache_page&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.\\&quot;;i:1;s:2281:\\&quot;user warning: Table &amp;#039;.\\\\dcgforum\\\\cache_page&amp;#039; is marke in C:\Sites\DCGForum\includes\database.mysql.inc on line 172