同一数据库中的图像和文本 [英] image and text in a same Database

问题描述

如何将图像和文本一起存储在同一个数据库中？

how to store image and a text together within a same Database?

推荐答案

只需使用单独的字段。我一直这样做：我在数据库中存储缩略图（100x100）的图像（2048x2048），以及实际图像的文本URL。 （我不会将实际图像存储在数据库中，因为DB'的大小限制也会严重影响带宽）

例如：

Just use separate fields. I do it all the time: I store a Thumbnail (100x100) of an image (2048x2048)in the database, along with a text URL to the actual image. (I don''t store the actual images in the DB as there are size limits on DB''s and also it can badly affect bandwidth)
For example:

USE [myDatabaseName]
GO
/****** Object:  Table [dbo].[Images]    Script Date: 01/05/2013 09:09:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Images](
	[Id] [uniqueidentifier] NOT NULL,
	[Location] [nvarchar](260) NOT NULL,
	[Thumbnail] [image] NOT NULL,
	[InsertDate] [datetime] NOT NULL,
	[Bytes] [bigint] NOT NULL,
 CONSTRAINT [PK_Images] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Default [DF_Images_InsertDate]    Script Date: 01/05/2013 09:09:34 ******/
ALTER TABLE [dbo].[Images] ADD  CONSTRAINT [DF_Images_InsertDate]  DEFAULT (((1900)-(1))-(1)) FOR [InsertDate]
GO
/****** Object:  Default [DF_Images_Bytes]    Script Date: 01/05/2013 09:09:34 ******/
ALTER TABLE [dbo].[Images] ADD  CONSTRAINT [DF_Images_Bytes]  DEFAULT ((-1)) FOR [Bytes]
GO

这篇关于同一数据库中的图像和文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！