Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

Data Type for storing URLs

Tags:

sql

database

What is the best data type to store URLs?

I need to save file system paths for pictures in a database.

like image

577

asked Jul 28 '10 08:07

GibboK

1 Answers

URLs are strings and will be of variable lenghts.

If your database system supports this, use VARCHAR.

like image

80

answered Sep 20 '22 22:09

Oded

Sign in to Comment

Related questions
                            
                                SQL Server: weighted average + GROUP BY
                            
                                Inconsistent behavior with `CROSS APPLY` and `OUTER APPLY`
                            
                                drop column only if exists in sql
                            
                                How to store H2 database file into project directory
                            
                                How to GROUP BY date with a timestamp field in Postgres?
                            
                                Optimize temporal table with CTE
                            
                                Unterminated dollar quote
                            
                                Oracle PL/SQL Query Order By issue with Distinct
                            
                                In SQL, How does using DISTINCT affect performance?
                            
                                When I call PreparedStatement.cancel() in a JDBC application, does it actually kill it in an Oracle database?
                            
                                SQL query engine for text files on Linux?
                            
                                SQL CREATE LOGON - can't use @parameter as username
                            
                                SQL Script to take a Microsoft Sql database online or offline?
                            
                                How do you use cfqueryparam in the ORDER BY clause?
                            
                                How can I enforce compound uniqueness in MySQL?
                            
                                Why a simple T-SQL UDF function makes the code execution 3 times slower
                            
                                SQL combining GROUP BY and SUM
                            
                                what is the correct way to format a datetime in SQL server datetime field
                            
                                Using case statement in update query
                            
                                Finding continuous ranges in a set of numbers

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With