Please enable JavaScript to use this web application.
Regular
Expressions
101
Social
Donate
Info
Regex Editor
Community Patterns
Account
Regex Quiz
Settings
Order By
Most Recent
Highest Score
Lowest Score
Most upvotes
Most downvotes
Filter by Flavor
PCRE2 (PHP >=7.3)
PCRE (PHP <7.3)
ECMAScript (JavaScript)
Python
Golang
Java 8
.NET 7.0 (C#)
Rust
Sponsors
Community Patterns
Search among 20,000 community submitted regex patterns...
There was a problem trying to fetch the library data. Please try again later.
Database datatype check
0
Regular Expression
Java 8
"
(?<type>
[
a
-
zA
-
Z2
]
*
)
(
\(
(?<precision>
\d
*
)
(
,
(?<scale>
\d
*
)
)?
\)
)?
"
gms
Open regex in editor
Description
Database data type determination and extraction. Example:
varchar(20)
varchar2(20)
number(20,3)
timestamp
Varchar(20)
Submitted by
anonymous
-
a year ago